Pandas Profiling Report

Dataset info

Number of variables	96
Number of observations	453
Missing cells	5393 (12.4%)
Duplicate rows	0 (0.0%)
Total size in memory	339.8 KiB
Average record size in memory	768.2 B

Variables types

Numeric	23
Categorical	41
Boolean	7
Date	0
URL	5
Text (Unique)	0
Rejected	20
Unsupported	0

Warnings

`access` has a high cardinality: 228 distinct values	Warning
`access` has 208 (45.9%) missing values	Missing
`amenities` has a high cardinality: 439 distinct values	Warning
`availability_30` has 199 (43.9%) zeros	Zeros
`availability_365` has 79 (17.4%) zeros	Zeros
`availability_60` is highly correlated with `availability_30` (ρ = 0.9201881394)	Rejected
`availability_90` is highly correlated with `availability_60` (ρ = 0.930129306)	Rejected
`bathrooms` has 10 (2.2%) zeros	Zeros
`bathrooms` has 12 (2.6%) missing values	Missing
`bedrooms` has 14 (3.1%) zeros	Zeros
`calendar_last_scraped` has constant value "2018-11-07"	Rejected
`cleaning_fee` has 48 (10.6%) missing values	Missing
`country` has constant value "Germany"	Rejected
`country_code` has constant value "DE"	Rejected
`description` has a high cardinality: 448 distinct values	Warning
`experiences_offered` has constant value "none"	Rejected
`first_review` has a high cardinality: 361 distinct values	Warning
`first_review` has 16 (3.5%) missing values	Missing
`has_availability` has constant value "t"	Rejected
`host_about` has a high cardinality: 367 distinct values	Warning
`host_about` has 11 (2.4%) missing values	Missing
`host_acceptance_rate` has constant value "nan"	Rejected
`host_listings_count` is highly correlated with `calculated_host_listings_count` (ρ = 0.969958062)	Rejected
`host_name` has a high cardinality: 317 distinct values	Warning
`host_response_rate` has 183 (40.4%) missing values	Missing
`host_response_time` has 183 (40.4%) missing values	Missing
`host_since` only contains datetime values, but is categorical. Consider applying `pd.to_datetime()`	Type
`host_since` has a high cardinality: 275 distinct values	Warning
`host_total_listings_count` is highly correlated with `host_listings_count` (ρ = 1)	Rejected
`host_verifications` has a high cardinality: 55 distinct values	Warning
`house_rules` has a high cardinality: 325 distinct values	Warning
`house_rules` has 114 (25.2%) missing values	Missing
`interaction` has a high cardinality: 195 distinct values	Warning
`interaction` has 237 (52.3%) missing values	Missing
`is_business_travel_ready` has constant value "f"	Rejected
`jurisdiction_names` has constant value "nan"	Rejected
`last_review` has a high cardinality: 218 distinct values	Warning
`last_review` has 16 (3.5%) missing values	Missing
`last_scraped` has constant value "2018-11-07"	Rejected
`license` has a high cardinality: 100 distinct values	Warning
`license` has 350 (77.3%) missing values	Missing
`market` has constant value "Berlin"	Rejected
`medium_url` has constant value "nan"	Rejected
`monthly_price` has a high cardinality: 113 distinct values	Warning
`monthly_price` has 195 (43.0%) missing values	Missing
`name` has a high cardinality: 452 distinct values	Warning
`neighborhood_overview` has a high cardinality: 220 distinct values	Warning
`neighborhood_overview` has 211 (46.6%) missing values	Missing
`neighbourhood` has 32 (7.1%) missing values	Missing
`neighbourhood_cleansed` has a high cardinality: 79 distinct values	Warning
`notes` has a high cardinality: 191 distinct values	Warning
`notes` has 243 (53.6%) missing values	Missing
`number_of_reviews` has 16 (3.5%) zeros	Zeros
`price` has a high cardinality: 104 distinct values	Warning
`requires_license` has constant value "t"	Rejected
`review_scores_accuracy` has 19 (4.2%) missing values	Missing
`review_scores_checkin` has 19 (4.2%) missing values	Missing
`review_scores_cleanliness` has 19 (4.2%) missing values	Missing
`review_scores_communication` has 19 (4.2%) missing values	Missing
`review_scores_location` has 19 (4.2%) missing values	Missing
`review_scores_rating` has 19 (4.2%) missing values	Missing
`review_scores_value` has 20 (4.4%) missing values	Missing
`reviews_per_month` is highly correlated with `number_of_reviews` (ρ = 0.9301967298)	Rejected
`scrape_id` has constant value "20181107122246"	Rejected
`security_deposit` has 114 (25.2%) missing values	Missing
`space` has a high cardinality: 435 distinct values	Warning
`space` has 6 (1.3%) missing values	Missing
`square_feet` has 45 (9.9%) zeros	Zeros
`square_feet` has 286 (63.1%) missing values	Missing
`summary` has a high cardinality: 285 distinct values	Warning
`summary` has 156 (34.4%) missing values	Missing
`thumbnail_url` has constant value "nan"	Rejected
`transit` has a high cardinality: 265 distinct values	Warning
`transit` has 164 (36.2%) missing values	Missing
`weekly_price` has a high cardinality: 106 distinct values	Warning
`weekly_price` has 184 (40.6%) missing values	Missing
`xl_picture_url` has constant value "nan"	Rejected
`zipcode` has a high cardinality: 107 distinct values	Warning

access
Categorical

Distinct count	228
Unique (%)	50.3%
Missing (%)	45.9%
Missing (n)	208

In addition to bedding and free towels, there are washers, dryers, TV and also free Wi-Fi available in the common room.	9
Ihr habt eine ganze Wohnung für Euch.	3
Bright and clean shared bathroom with shower. No kitchen!	2
Other values (224)	231
(Missing)	208

Toggle details

Common values
Composition

Value	Count	Frequency (%)
In addition to bedding and free towels, there are washers, dryers, TV and also free Wi-Fi available in the common room.	9	2.0%
Ihr habt eine ganze Wohnung für Euch.	3	0.7%
Bright and clean shared bathroom with shower. No kitchen!	2	0.4%
As our guest you will have the whole apartment to yourself. You won’t have to share it with anybody else. You may also use the courtyard to store your bicycle.	2	0.4%
There is two good bathrooms in the apartment. For your personal convenience while staying here I'm offering a selection of skincare products in both bathrooms. The kitchen is well equipped and there is good space to do some lightly cooking, sit and enjoy your meal, maybe work or use the internet. There is of course a fridge with freezer, where you can store your food and a microwave oven if you want to heat food. I also offer a variety of tea and coffees during your stay. Further offers are; hair-dryer, iron and ironing board and of course wireless/WiFi Internet. There is also a desk in each room.	2	0.4%
Sie mieten die gesamte Wohnung. Niemand anderes hat Zugang.	2	0.4%
The apartment is ideal for 2 adults and a maximum of 2 children.	2	0.4%
das große Grundstück 1400 m² erwartet Sie mit einer 18 Meter breiten Wasserfläche an der Sie Sich sonnen können und auch direkt am Wasser Ihre Mahlzeiten einnehmen können, oder eine Drink mit dem Blick auf dem Seddinsee genießen können	2	0.4%
Included in the price are fresh sheets and towels, the common use of the bathroom, guest toilet, kitchen and living room as well as the internet acccess.	2	0.4%
Fri Parkering & Internet Mycket nära till det mesta	2	0.4%
Other values (217)	217	47.9%
(Missing)	208	45.9%

Max length	1000
Mean length	93.09050773
Min length	3
Contains chars	True
Contains digits	True
Contains spaces	True
Contains non-words	True

accommodates
Numeric

Distinct count	12
Unique (%)	2.6%
Missing (%)	0.0%
Missing (n)	0
Infinite (%)	0.0%
Infinite (n)	0

Mean	3.112582781
Minimum	1
Maximum	15
Zeros (%)	0.0%

Toggle details

Quantile statistics

Minimum	1
5-th percentile	1
Q1	2
Median	2
Q3	4
95-th percentile	6
Maximum	15
Range	14
Interquartile range	2

Descriptive statistics

Standard deviation	1.788148223
Coef of variation	0.5744901737
Kurtosis	8.574939951
Mean	3.112582781
MAD	1.347952575
Skewness	2.189810225
Sum	1410
Variance	3.197474067
Memory size	3.6 KiB

Histogram with fixed size bins (bins=12)

Histogram with variable size bins (bins=[ 1. 1.5 2.5 3.5 4.5 6.5 9. 15. ], "bayesian blocks" binning strategy used)

Value	Count	Frequency (%)
2	207	45.7%
4	96	21.2%
3	47	10.4%
1	33	7.3%
5	31	6.8%
6	24	5.3%
8	8	1.8%
10	2	0.4%
7	2	0.4%
15	1	0.2%
Other values (2)	2	0.4%

Minimum 5 values

Value	Count	Frequency (%)
1	33	7.3%
2	207	45.7%
3	47	10.4%
4	96	21.2%
5	31	6.8%

Maximum 5 values

Value	Count	Frequency (%)
15	1	0.2%
14	1	0.2%
12	1	0.2%
10	2	0.4%
8	8	1.8%

amenities
Categorical

Distinct count	439
Unique (%)	96.9%
Missing (%)	0.0%
Missing (n)	0

{Internet,Wifi,Kitchen,Heating,"Family/kid friendly","Lock on bedroom door",Hangers,"Hot water"}	3
{TV,Internet,Wifi,Heating,"Family/kid friendly",Washer,Dryer,"Smoke detector","Carbon monoxide detector","Safety card","Fire extinguisher",Essentials,"Hair dryer",Iron,"Bed linens","Host greets you"}	2
{}	2
Other values (436)	446

Toggle details

Common values
Composition

Value	Count	Frequency (%)
{Internet,Wifi,Kitchen,Heating,"Family/kid friendly","Lock on bedroom door",Hangers,"Hot water"}	3	0.7%
{TV,Internet,Wifi,Heating,"Family/kid friendly",Washer,Dryer,"Smoke detector","Carbon monoxide detector","Safety card","Fire extinguisher",Essentials,"Hair dryer",Iron,"Bed linens","Host greets you"}	2	0.4%
{}	2	0.4%
{TV,Internet,Wifi,Kitchen,"Buzzer/wireless intercom",Heating,Washer,"Smoke detector",Hangers,"Private entrance","Hot water","Ethernet connection","Host greets you"}	2	0.4%
{TV,Internet,Wifi,Kitchen,"Buzzer/wireless intercom",Heating,"Family/kid friendly",Washer,Essentials,Hangers,"Hair dryer","Laptop friendly workspace"}	2	0.4%
{TV,Internet,Wifi,"Paid parking off premises",Heating,"Family/kid friendly",Washer,Dryer,"Smoke detector","Carbon monoxide detector","Safety card","Fire extinguisher",Essentials,"Hair dryer",Iron,"Bed linens","Host greets you"}	2	0.4%
{Internet,Wifi,Kitchen,Heating,"Family/kid friendly",Washer}	2	0.4%
{TV,"Cable TV",Internet,Wifi,Kitchen,Heating,"Family/kid friendly"}	2	0.4%
{TV,"Cable TV",Internet,Wifi,Kitchen,Elevator,"Buzzer/wireless intercom",Heating}	2	0.4%
{TV,Internet,Wifi,"Paid parking off premises",Heating,"Family/kid friendly",Washer,Dryer,"Smoke detector","Carbon monoxide detector","Safety card","Fire extinguisher",Essentials,"Hair dryer",Iron,"Host greets you"}	2	0.4%
Other values (429)	432	95.4%

Max length	1006
Mean length	301.8366446
Min length	2
Contains chars	True
Contains digits	True
Contains spaces	True
Contains non-words	True

availability_30
Numeric

Distinct count	31
Unique (%)	6.8%
Missing (%)	0.0%
Missing (n)	0
Infinite (%)	0.0%
Infinite (n)	0

Mean	7.300220751
Minimum	0
Maximum	30
Zeros (%)	43.9%

Toggle details

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
Median	3
Q3	13
95-th percentile	28
Maximum	30
Range	30
Interquartile range	13

Descriptive statistics

Standard deviation	9.289251803
Coef of variation	1.272461768
Kurtosis	-0.04082647183
Mean	7.300220751
MAD	7.6850528
Skewness	1.113316295
Sum	3307
Variance	86.29019907
Memory size	3.6 KiB

Histogram with fixed size bins (bins=31)

Histogram with variable size bins (bins=[ 0. 0.5 9.5 29.5 30. ], "bayesian blocks" binning strategy used)

Value	Count	Frequency (%)
0	199	43.9%
6	26	5.7%
1	13	2.9%
3	13	2.9%
8	13	2.9%
5	12	2.6%
9	11	2.4%
29	10	2.2%
2	10	2.2%
4	10	2.2%
Other values (21)	136	30.0%

Minimum 5 values

Value	Count	Frequency (%)
0	199	43.9%
1	13	2.9%
2	10	2.2%
3	13	2.9%
4	10	2.2%

Maximum 5 values

Value	Count	Frequency (%)
30	10	2.2%
29	10	2.2%
28	4	0.9%
27	8	1.8%
26	3	0.7%

availability_365
Numeric

Distinct count	205
Unique (%)	45.3%
Missing (%)	0.0%
Missing (n)	0
Infinite (%)	0.0%
Infinite (n)	0

Mean	174.8300221
Minimum	0
Maximum	365
Zeros (%)	17.4%

Toggle details

Quantile statistics

Minimum	0
5-th percentile	0
Q1	32
Median	191
Q3	302
95-th percentile	352
Maximum	365
Range	365
Interquartile range	270

Descriptive statistics

Standard deviation	130.2403998
Coef of variation	0.7449544323
Kurtosis	-1.541630299
Mean	174.8300221
MAD	118.648763
Skewness	-0.1015411187
Sum	79198
Variance	16962.56175
Memory size	3.6 KiB

Histogram with fixed size bins (bins=50)

Histogram with variable size bins (bins=[ 0. 0.5 5.5 242.5 365. ], "bayesian blocks" binning strategy used)

Value	Count	Frequency (%)
0	79	17.4%
352	6	1.3%
159	6	1.3%
310	6	1.3%
129	5	1.1%
275	5	1.1%
311	5	1.1%
341	5	1.1%
365	5	1.1%
211	4	0.9%
Other values (195)	327	72.2%

Minimum 5 values

Value	Count	Frequency (%)
0	79	17.4%
1	4	0.9%
2	1	0.2%
3	4	0.9%
4	1	0.2%

Maximum 5 values

Value	Count	Frequency (%)
365	5	1.1%
364	2	0.4%
363	2	0.4%
362	4	0.9%
361	1	0.2%

availability_60
Highly correlated

This variable is highly correlated with availability_30 and should be ignored for analysis

Correlation	0.9201881394

availability_90
Highly correlated

This variable is highly correlated with availability_60 and should be ignored for analysis

Correlation	0.930129306

bathrooms
Numeric

Distinct count	8
Unique (%)	1.8%
Missing (%)	2.6%
Missing (n)	12
Infinite (%)	0.0%
Infinite (n)	0

Mean	1.10430839
Minimum	0
Maximum	5
Zeros (%)	2.2%

Toggle details

Quantile statistics

Minimum	0
5-th percentile	1
Q1	1
Median	1
Q3	1
95-th percentile	2
Maximum	5
Range	5
Interquartile range	0

Descriptive statistics

Standard deviation	0.4078820408
Coef of variation	0.3693551951
Kurtosis	21.11016162
Mean	1.10430839
MAD	0.2273795384
Skewness	2.904984804
Sum	487
Variance	0.1663677592
Memory size	3.6 KiB

Histogram with fixed size bins (bins=8)

Value	Count	Frequency (%)
1	369	81.5%
2	33	7.3%
1.5	21	4.6%
0	10	2.2%
2.5	6	1.3%
5	1	0.2%
0.5	1	0.2%
(Missing)	12	2.6%

Minimum 5 values

Value	Count	Frequency (%)
0	10	2.2%
0.5	1	0.2%
1	369	81.5%
1.5	21	4.6%
2	33	7.3%

Maximum 5 values

Value	Count	Frequency (%)
5	1	0.2%
2.5	6	1.3%
2	33	7.3%
1.5	21	4.6%
1	369	81.5%

bed_type
Categorical

Distinct count	4
Unique (%)	0.9%
Missing (%)	0.0%
Missing (n)	0

Real Bed	433
Pull-out Sofa	12
Futon	7

Toggle details

Common values
Composition

Value	Count	Frequency (%)
Real Bed	433	95.6%
Pull-out Sofa	12	2.6%
Futon	7	1.5%
Couch	1	0.2%

Max length	13
Mean length	8.079470199
Min length	5
Contains chars	True
Contains digits	False
Contains spaces	True
Contains non-words	True

bedrooms
Numeric

Distinct count	8
Unique (%)	1.8%
Missing (%)	0.2%
Missing (n)	1
Infinite (%)	0.0%
Infinite (n)	0

Mean	1.28539823
Minimum	0
Maximum	8
Zeros (%)	3.1%

Toggle details

Quantile statistics

Minimum	0
5-th percentile	1
Q1	1
Median	1
Q3	1
95-th percentile	2
Maximum	8
Range	8
Interquartile range	0

Descriptive statistics

Standard deviation	0.7050398682
Coef of variation	0.5484991746
Kurtosis	20.51870207
Mean	1.28539823
MAD	0.4913070718
Skewness	3.117379818
Sum	581
Variance	0.4970812158
Memory size	3.6 KiB

Histogram with fixed size bins (bins=8)

Value	Count	Frequency (%)
1	326	72.0%
2	91	20.1%
3	16	3.5%
0	14	3.1%
4	3	0.7%
8	1	0.2%
5	1	0.2%
(Missing)	1	0.2%

Minimum 5 values

Value	Count	Frequency (%)
0	14	3.1%
1	326	72.0%
2	91	20.1%
3	16	3.5%
4	3	0.7%

Maximum 5 values

Value	Count	Frequency (%)
8	1	0.2%
5	1	0.2%
4	3	0.7%
3	16	3.5%
2	91	20.1%

beds
Numeric

Distinct count	12
Unique (%)	2.6%
Missing (%)	0.2%
Missing (n)	1
Infinite (%)	0.0%
Infinite (n)	0

Mean	2.134955752
Minimum	0
Maximum	15
Zeros (%)	0.2%

Toggle details

Quantile statistics

Minimum	0
5-th percentile	1
Q1	1
Median	2
Q3	3
95-th percentile	5
Maximum	15
Range	15
Interquartile range	2

Descriptive statistics

Standard deviation	1.708701935
Coef of variation	0.8003453625
Kurtosis	15.33834238
Mean	2.134955752
MAD	1.135464798
Skewness	3.061941344
Sum	965
Variance	2.919662304
Memory size	3.6 KiB

Histogram with fixed size bins (bins=12)

Value	Count	Frequency (%)
1	209	46.1%
2	128	28.3%
3	48	10.6%
4	28	6.2%
5	17	3.8%
6	12	2.6%
8	5	1.1%
15	2	0.4%
10	1	0.2%
0	1	0.2%

Minimum 5 values

Value	Count	Frequency (%)
0	1	0.2%
1	209	46.1%
2	128	28.3%
3	48	10.6%
4	28	6.2%

Maximum 5 values

Value	Count	Frequency (%)
15	2	0.4%
10	1	0.2%
8	5	1.1%
7	1	0.2%
6	12	2.6%

calculated_host_listings_count
Numeric

Distinct count	11
Unique (%)	2.4%
Missing (%)	0.0%
Missing (n)	0
Infinite (%)	0.0%
Infinite (n)	0

Mean	2.105960265
Minimum	1
Maximum	14
Zeros (%)	0.0%

Toggle details

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
Median	1
Q3	2
95-th percentile	6
Maximum	14
Range	13
Interquartile range	1

Descriptive statistics

Standard deviation	2.396953222
Coef of variation	1.138175901
Kurtosis	12.99339721
Mean	2.105960265
MAD	1.376723243
Skewness	3.506092283
Sum	954
Variance	5.745384751
Memory size	3.6 KiB

Histogram with fixed size bins (bins=11)

Histogram with variable size bins (bins=[ 1. 1.5 2.5 4.5 14. ], "bayesian blocks" binning strategy used)

Value	Count	Frequency (%)
1	274	60.5%
2	83	18.3%
3	43	9.5%
4	27	6.0%
14	9	2.0%
11	5	1.1%
10	5	1.1%
6	3	0.7%
7	2	0.4%
9	1	0.2%

Minimum 5 values

Value	Count	Frequency (%)
1	274	60.5%
2	83	18.3%
3	43	9.5%
4	27	6.0%
5	1	0.2%

Maximum 5 values

Value	Count	Frequency (%)
14	9	2.0%
11	5	1.1%
10	5	1.1%
9	1	0.2%
7	2	0.4%

calendar_last_scraped
Constant

This variable is constant and should be ignored for analysis

Constant value	2018-11-07

calendar_updated
Categorical

Distinct count	42
Unique (%)	9.3%
Missing (%)	0.0%
Missing (n)	0

today	105
a week ago	34
2 months ago	32
Other values (39)	282

Toggle details

Common values
Composition

Value	Count	Frequency (%)
today	105	23.2%
a week ago	34	7.5%
2 months ago	32	7.1%
2 weeks ago	29	6.4%
yesterday	27	6.0%
3 weeks ago	26	5.7%
3 months ago	19	4.2%
3 days ago	16	3.5%
4 months ago	16	3.5%
5 weeks ago	14	3.1%
Other values (32)	135	29.8%

Max length	13
Mean length	9.626931567
Min length	5
Contains chars	True
Contains digits	True
Contains spaces	True
Contains non-words	True

cancellation_policy
Categorical

Distinct count	3
Unique (%)	0.7%
Missing (%)	0.0%
Missing (n)	0

strict_14_with_grace_period	255
moderate	147
flexible	51

Toggle details

Common values
Composition

Value	Count	Frequency (%)
strict_14_with_grace_period	255	56.3%
moderate	147	32.5%
flexible	51	11.3%

Max length	27
Mean length	18.69536424
Min length	8
Contains chars	True
Contains digits	True
Contains spaces	False
Contains non-words	False

city
Categorical

Distinct count	3
Unique (%)	0.7%
Missing (%)	0.0%
Missing (n)	0

Berlin	451
Berlin (Kreuzberg)	1
Schöneberg	1

Toggle details

Common values
Composition

Value	Count	Frequency (%)
Berlin	451	99.6%
Berlin (Kreuzberg)	1	0.2%
Schöneberg	1	0.2%

Max length	18
Mean length	6.035320088
Min length	6
Contains chars	True
Contains digits	False
Contains spaces	True
Contains non-words	True

cleaning_fee
Categorical

Distinct count	47
Unique (%)	10.4%
Missing (%)	10.6%
Missing (n)	48

$30.00	60
$50.00	44
$20.00	39
Other values (43)	262
(Missing)	48

Toggle details

Common values
Composition

Value	Count	Frequency (%)
$30.00	60	13.2%
$50.00	44	9.7%
$20.00	39	8.6%
$0.00	37	8.2%
$40.00	37	8.2%
$35.00	28	6.2%
$25.00	24	5.3%
$15.00	22	4.9%
$60.00	18	4.0%
$10.00	11	2.4%
Other values (36)	85	18.8%
(Missing)	48	10.6%

Max length	7
Mean length	5.620309051
Min length	3
Contains chars	True
Contains digits	True
Contains spaces	False
Contains non-words	True

country
Constant

This variable is constant and should be ignored for analysis

Constant value	Germany

country_code
Constant

This variable is constant and should be ignored for analysis

Constant value	DE

description
Categorical

Distinct count	448
Unique (%)	98.9%
Missing (%)	0.2%
Missing (n)	1

Exceptional guestroom in the back of the legendary Berlin Kinomuseum. We offer one single and one double room, regulary Salon Evenings and Film Screenings. Truly unique in Berlin! Bright and clean shared bathroom with shower. No kitchen! U8 Schönleinstraße No place for party people!	2
Welcome to a feel good stay and a quality experience in Berlin. We're offering mature hospitality, good quality in our interior with good beds, you´ll love sleeping in. This is the place to stay, if you want to experience a relaxed however stylish alternative to a hotel we're the place. You're now reading about a semi-professional host's offer to guests visiting Berlin. It means I have more rooms for rent out in the same big and spacey apartment - a 'guest house'. So be course I'm not a newbie in this business is a greater chance for at good stay in Berlin, then if you take a host with no experience and on the hunt for some extra pocket money. I charge a bit more then the other hosts, I don't offer discounts and in return the only thing I'm working for is to provide a good stay and a good nights sleep for my guests. Great apartment, great room, big kitchen and two baths/toilets! The room is big and spacious and decorated to give you a space to relax. The apartment is in a very quiet	2
Large room that can accommodate up to 6 people. It has 3 bunk beds and is very suitable for small groups. The spacious bathroom is for multiple rooms. Our Sunflower Hostel is characterized by its colorful and unconventional design, and offers plenty of space to meet and to exchange with other travelers. For this purpose especially our lobby invites with a bar, table football, plenty of seating and even a small pond with fishes! In addition to bedding and free towels, there are washers, dryers, TV and also free Wi-Fi available in the common room. You will be welcomed by our friendly and open Staff, who will help you with good advices and guarantee a great stay in our hostel. Home of this pretty accommodation is Friedrichshain, one of the central districs in Berlin, surrounded by Prenzlauer Berg, Mitte and Kreuzberg. Friedrichshain distinguishes himself as a student and artist district by its young and creative activities. Primarily due to the numerous bars, cafes, restaurants, galleries	2
Other values (444)	446

Toggle details

Common values
Composition

Value	Count	Frequency (%)
Exceptional guestroom in the back of the legendary Berlin Kinomuseum. We offer one single and one double room, regulary Salon Evenings and Film Screenings. Truly unique in Berlin! Bright and clean shared bathroom with shower. No kitchen! U8 Schönleinstraße No place for party people!	2	0.4%
Welcome to a feel good stay and a quality experience in Berlin. We're offering mature hospitality, good quality in our interior with good beds, you´ll love sleeping in. This is the place to stay, if you want to experience a relaxed however stylish alternative to a hotel we're the place. You're now reading about a semi-professional host's offer to guests visiting Berlin. It means I have more rooms for rent out in the same big and spacey apartment - a 'guest house'. So be course I'm not a newbie in this business is a greater chance for at good stay in Berlin, then if you take a host with no experience and on the hunt for some extra pocket money. I charge a bit more then the other hosts, I don't offer discounts and in return the only thing I'm working for is to provide a good stay and a good nights sleep for my guests. Great apartment, great room, big kitchen and two baths/toilets! The room is big and spacious and decorated to give you a space to relax. The apartment is in a very quiet	2	0.4%
Large room that can accommodate up to 6 people. It has 3 bunk beds and is very suitable for small groups. The spacious bathroom is for multiple rooms. Our Sunflower Hostel is characterized by its colorful and unconventional design, and offers plenty of space to meet and to exchange with other travelers. For this purpose especially our lobby invites with a bar, table football, plenty of seating and even a small pond with fishes! In addition to bedding and free towels, there are washers, dryers, TV and also free Wi-Fi available in the common room. You will be welcomed by our friendly and open Staff, who will help you with good advices and guarantee a great stay in our hostel. Home of this pretty accommodation is Friedrichshain, one of the central districs in Berlin, surrounded by Prenzlauer Berg, Mitte and Kreuzberg. Friedrichshain distinguishes himself as a student and artist district by its young and creative activities. Primarily due to the numerous bars, cafes, restaurants, galleries	2	0.4%
The accommodation is located in the district of Neukölln, in the middle of the old Bohemian Rixdorf, a historical working class quarter that was once founded in 1737. Berlin-Neukölln offers many cafés, bars and shopping opportunities, international cultural offerings such as the Neukölln opera, movies, numerous galleries as well as the Volkspark Hasenheide are within walking distance. We offer single, double, 3 beds rooms and a holiday home. There are 2 shared bathrooms and a small kitchen available for the rooms. They are also suitable for small groups of up to 10 persons. The holiday apartment is suitable for up to 4 persons and is situated on the 2nd floor. It has 1 room with TV, bathroom, kitchen and a washing machine. Berlin offers many opportunities to experience both historical & modern culture and space to relax. The growing together of East and West can be intensely experienced in Berlin, in particular. Among the most attracting sights you find the historical city center with	2	0.4%
Lovely Apartment for two persons. Nice and sunny reasonable Apartment, 35 qm, modernized, quietly, traffic favourable.	2	0.4%
A beautiful quiet town house surrounded by a large garden, next to a beautiful Fin de Siecle Villa, ten minutes by train to downtown, Berlinale Potsdamer Platz and close to the Free University. Large Bathroom, large kitchen, large living room. Freistehendes,möbliertes Haus in nicht einsehbarer Gartenanlage in Südwest-Berlin mit eigenem Eingang zwischen alten Bäumen,neben denkmalgeschützter Gründervilla. Frisch renovierte ca 65 qm, ein grosser Raum mit eingebauter Küche. Bad mit grosser Badewanne und Waschmaschine. Grillplatz, Garten. Super Verkehrsanbindung. Per Schnellbahn ist man in 10 Min am Potsdamer Platz, zwei weitere Busse halten direkt vor dem Haus.Wir freuen uns Euch hier zu Gast zu haben. Irina und Jochen	1	0.2%
Attention - there is a construction site nearby. Maybe there will be some noise from 7 am - 4 pm A comfortable room in the heart of Berlin, between Mitte and Prenzlauer Berg. Just a few steps away from Kollwitzplatz and Kastanienallee with a variety of cafes, restaurants and art galleries. The subway stations Senefelder Platz (U2) and Rosenthaler Platz (U8) are just around the corner. Alexanderplatz, the Pergamon Museum and the Berlin Wall Documentation Centre are convenient walking distances, as is Hackescher Markt with its artsy boutiques and unique shopping experience. The famous Sunday fleamarket is also nearby at Mauerpark. There are many places to rent bikes and to start exploring the city by bus or by foot. The neighborhood is a focal point of Berlin’s unique nightlife. The room is part of a modern, newly designed penthouse, on the fourth floor of a beautiful, historical landmark from the 19th century. A modern bathroom including stylish sink, shower, and tub are integrated in t	1	0.2%
The apartment is located in the center of Berlin and is nevertheless very quiet. It is possible to stay until 5 persons. Many shops, cafes, restaurants and sights are within walking distance. Also a good city train and subway connection We welcome you to our apartment Features: • 2-room apartment on the ground floor to the left in an old building • Front building • WiFi included !!! • approx. 65 sq m • Attractive and well-maintained furnishings • central location in quiet side street - 1000 m to the main station For tourists Living and bedroom: • Futon (1,40 m) •Table • Armchair (extra bed (0,90 m)) • TV • Radio • Dresser • Connecting room Bedroom: • Double bed (1,60 m) • Wardrobes Bathroom: • Bathroom • Sink • Shower Kitchen: • Stove • Ceran stovetop •Refrigerator • Dishwasher • Coffee machine • Water boiler • Toaster • large dining table with 5 chairs Location & area: • Museum of Natural Science and Oranienburger Strasse approx. 500 min away Charité, Museumsinsel and Hackesche Höfe	1	0.2%
Bursting with energy and charisma this cosy 1bedroom-apartment in a pretty period building is the perfect venture point for all your city activities in Berlin. It lies right in the centre of everything, in the famous Berlin Mitte (as central as it gets) district. Cafes, bars, clubs, cinemas, theaters, galleries, sight seeing, supermarkets, shops and public transport aplenty are all within easiest reach. It comes with many creature comforts: WiFi, bathtub, fully-equipped kitchen, comfy bed, balcony... From the little balcony you have a view of lovely Linienstraße and the chic cafe opposite with its adjacent bike rental. This is a very homely and fully equipped urban dwelling that with its tonnes of character and quirky interior will turn you into a Berliner during your stay. Your hostess is a restless reporter calling this place home when she is not calling the shots on a shoot somewhere and hence inviting special guests into this inner sanctum. You will be glad you came:)	1	0.2%
Bright and sunny condo with two balconies in a stunning location in Berlin Mitte/Prenzelberg! A 100 qm fancy and bright designer loft condo, in the heart of famous Prenzlauer Berg, partly exposed brickwork and fire place. 2 bedrooms plus huge living space with kitchen. 2 TVs, one in the master bedroom including a dvd player, and one in the living room. Washing machine plus dryer included The loft is in the 5th floor (with elevator). Fantastic view down the Kastanienallee and to the television tower (Alex). By foot you have several bars, clubs, little shops (books, art, fashion) theater and independent movie theatres, right around the corner. The Kastanienallee is one of the most vibrant spots in Prenzlauer Berg, and leads you to the famous Mauerpark with its attached big flea market on sundays. Public transportation like the Tram M1 is just a few meters away, which leads you directly to Hackescher Markt, through Oranienburger Strasse, to Friedrichstrasse and Unter den Linden. The U	1	0.2%
Other values (437)	437	96.5%

Max length	1000
Mean length	923.0242826
Min length	3
Contains chars	True
Contains digits	True
Contains spaces	True
Contains non-words	True

experiences_offered
Constant

This variable is constant and should be ignored for analysis

Constant value	none

extra_people
Categorical

Distinct count	32
Unique (%)	7.1%
Missing (%)	0.0%
Missing (n)	0

$0.00	96
$10.00	83
$20.00	56
Other values (29)	218

Toggle details

Common values
Composition

Value	Count	Frequency (%)
$0.00	96	21.2%
$10.00	83	18.3%
$20.00	56	12.4%
$15.00	55	12.1%
$25.00	27	6.0%
$5.00	23	5.1%
$30.00	16	3.5%
$12.00	15	3.3%
$18.00	12	2.6%
$19.00	7	1.5%
Other values (22)	63	13.9%

Max length	7
Mean length	5.706401766
Min length	5
Contains chars	False
Contains digits	True
Contains spaces	False
Contains non-words	True

first_review
Categorical

Distinct count	361
Unique (%)	79.7%
Missing (%)	3.5%
Missing (n)	16

2012-05-01	4
2012-07-23	4
2012-06-26	4
Other values (357)	425
(Missing)	16

Toggle details

Common values
Composition

Value	Count	Frequency (%)
2012-05-01	4	0.9%
2012-07-23	4	0.9%
2012-06-26	4	0.9%
2012-01-04	4	0.9%
2012-06-04	3	0.7%
2012-05-07	3	0.7%
2012-07-09	3	0.7%
2012-04-17	3	0.7%
2012-05-30	3	0.7%
2012-08-16	3	0.7%
Other values (350)	403	89.0%
(Missing)	16	3.5%

Max length	10
Mean length	9.752759382
Min length	3
Contains chars	True
Contains digits	True
Contains spaces	False
Contains non-words	True

guests_included
Numeric

Distinct count	7
Unique (%)	1.5%
Missing (%)	0.0%
Missing (n)	0
Infinite (%)	0.0%
Infinite (n)	0

Mean	1.589403974
Minimum	1
Maximum	8
Zeros (%)	0.0%

Toggle details

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
Median	1
Q3	2
95-th percentile	3
Maximum	8
Range	7
Interquartile range	1

Descriptive statistics

Standard deviation	0.8513772537
Coef of variation	0.5356581888
Kurtosis	10.77773535
Mean	1.589403974
MAD	0.6453518121
Skewness	2.538407777
Sum	720
Variance	0.724843228
Memory size	3.6 KiB

Histogram with fixed size bins (bins=7)

Histogram with variable size bins (bins=[1. 1.5 2.5 4.5 8. ], "bayesian blocks" binning strategy used)

Value	Count	Frequency (%)
1	248	54.7%
2	173	38.2%
4	17	3.8%
3	11	2.4%
6	2	0.4%
8	1	0.2%
5	1	0.2%

Minimum 5 values

Value	Count	Frequency (%)
1	248	54.7%
2	173	38.2%
3	11	2.4%
4	17	3.8%
5	1	0.2%

Maximum 5 values

Value	Count	Frequency (%)
8	1	0.2%
6	2	0.4%
5	1	0.2%
4	17	3.8%
3	11	2.4%

has_availability
Constant

This variable is constant and should be ignored for analysis

Constant value	t

host_about
Categorical

Distinct count	367
Unique (%)	81.0%
Missing (%)	2.4%
Missing (n)	11

Hallo, wir freuen uns sehr auf freundliche Gäste aus aller Welt und begrüßen Euch ganz herzlich! Im Sunflower Hostel stehen euch gemischte Mehrbettzimmer und geschlechtergetrennte Gemeinschaftsbäder zur Verfügung. Des Weiteren erwarten euch freundliches Personal, die weltweit größte Outdoor-Raucher-Lounge und eine 23h-Bar. Für eure Wünsche und Fragen haben wir rund um die Uhr ein offenes Ohr und helfen euch gern weiter mit Empfehlungen, Wegbeschreibungen etc. Wir freuen uns auf Eure Anfragen! Euer Sunflower-Team	9
Herzlich willkommen in meiner Unterkunft in Berlin Neukölln Ich würde mich freuen, wenn Ihr Euch für meine Wohnung entscheidet und stehe Euch gerne mit Tipps zur Seite.	5
Hey wir, Wolfgang und Ute Lehnert, freuen uns auf nette Gäste aus der ganzen Welt. Wir sind froh unsere Kultur und Sehenswürdigkeiten mit anderen teilen zu können.	4
Other values (363)	424
(Missing)	11

Toggle details

Common values
Composition

Value	Count	Frequency (%)
Hallo, wir freuen uns sehr auf freundliche Gäste aus aller Welt und begrüßen Euch ganz herzlich! Im Sunflower Hostel stehen euch gemischte Mehrbettzimmer und geschlechtergetrennte Gemeinschaftsbäder zur Verfügung. Des Weiteren erwarten euch freundliches Personal, die weltweit größte Outdoor-Raucher-Lounge und eine 23h-Bar. Für eure Wünsche und Fragen haben wir rund um die Uhr ein offenes Ohr und helfen euch gern weiter mit Empfehlungen, Wegbeschreibungen etc. Wir freuen uns auf Eure Anfragen! Euer Sunflower-Team	9	2.0%
Herzlich willkommen in meiner Unterkunft in Berlin Neukölln Ich würde mich freuen, wenn Ihr Euch für meine Wohnung entscheidet und stehe Euch gerne mit Tipps zur Seite.	5	1.1%
Hey wir, Wolfgang und Ute Lehnert, freuen uns auf nette Gäste aus der ganzen Welt. Wir sind froh unsere Kultur und Sehenswürdigkeiten mit anderen teilen zu können.	4	0.9%
Hallo zusammen, mein Name ist Joe! Ich freue mich über viele nette Gäste aus aller Welt.	4	0.9%
Ich habe mit der Eröffnung der Ferienwohnung in Berlin Heiligensee schon 2004 angefangen - das Ferienhaus Dressler am Wasser und die Ferienwohnung am Wasser kamen 2010 hinzu .Viele zufriedene Gäste haben sich in diesen Jahren wie zuhause gefühlt - wann kommen Si (Website hidden by Airbnb) unter (Website hidden by Airbnb) gibt es alle schönen Bilder	4	0.9%
We are a laid back Irish-Polish/German couple. We moved to Berlin about six years ago and are really loving it here. It's an amazing city and we are looking forward to sharing our favourite Berlin spots with you. We have prepared an extensive guide book for all our guests with many tips on what to do in Berlin, where to eat and where to go out in the evening. It also has a section for parents and tips for the winter and for the summer. We are looking forward to hosting you in our apartments!	4	0.9%
Sehr geehrte Gäste, Einen schönen Guten Tag ! Wir sind Bernd und Tamara. Unsere Sprachen sind Deutsch , Englisch, Russisch und wir freuen uns darauf, Sie bei uns in Berlin begrüssen zu dürfen. Bei uns werden Sie sich wohlfühlen! Dear Guests, Greetings to you from Berlin ! We are Bernd and Tamara. Our languages are German and English, and we are looking forward to having you as our guests here in Berlin ! We are certain that you will enjoy your stay with us ! Profil of Bernd: Born 1940 in Königsberg/East Prussia, - Territory now belonging to Russia. - At age 4, family escaped to the former East Germany. After Public School: Professional Letter as Factory Mechanic. Refusal of East German Government to my entering College, because of Membership at Protestant Church-Youth Organization, where I sang in a Church-Choir and played the Trompet at Church-Functions. Age 16 !!: Coal Miner in a Brown-Coal Pit !!! "Move" !!! (officially denounced and documented as illegal) to the former West Germany. - In Wiesbaden: Professional Letter as Machine Draftsman, and Work as Machine Designer in the Field of Chemical-Process-Machines. 1968 in New York City: Machine Designer and Student at New York City College: Bachelor of Arts in 1972. Major Direction of Study: Psychology, Minor: German Literature. At the Caribbean Island-State of St. Kitts-Nevis/West Indies (Leeward Islands): Lecturer of Technical Drawing at the Technical College in St. Kitts/West Indies, and Math-Teacher at Gingerland High-School in Nevis/West Indies, having taught in the British O-Level System. - In St. Kitts: the Founding of a Chess-Club, meeting once a week ! (It still was functioning 10 years later) (Website hidden by Airbnb) The Date of Independance from Britain is the 19th of September, which also is my Birthday ! In 1976, back to the U.S., to Chicago: Real Estate Salesman & Manager. Work with Procter & Gamble. Purchase and Sale of vacant, - old and broken-down Buildings. Restauration of those Buildings. Rental of their Apartments after Re-Hab. (To be continued).	4	0.9%
Ich heiße alle Gäste , die die meine aufregende Stadt Berlin kennen lernen wollen herzlich willkommen. Nach dem Motto : immer leben und leben lassen bin ich gerne Gastgeberin für fast alle Menschen aus aller Welt, von nah und fern. Bei mir soll man sich wohl fühlen und wiederkommen.	4	0.9%
Ich bin hilfsbereit, gastfreundlich und freue mich immer wieder neue und interessante Leute aus der ganzen Welt kennenzulernen.	3	0.7%
Ich freue mich auf Gäste aus aller Welt und hoffe, dass sie sich bei mir wohlfühlen. Nachdem ich mit dem Beginn meines Rentenalters meinen größeren Vermietungsservice verkaufte, habe ich nur eine schöne Wohnung ganz nahe meiner eigenen Wohnung zum Vermieten behalten. Hier kann ich mich persönlich um alles in der Gästewohnung kümmern und die ankommenden Gäste direkt vor der Haustür begrüßen. Leider spreche ich nicht besonders gut Englisch, aber bisher hat eine Verständigung doch immer noch funktioniert, am besten ist es per Email möglich, da habe ich Zeit zum übersetzen.^^	3	0.7%
Other values (356)	398	87.9%
(Missing)	11	2.4%

Max length	2113
Mean length	283.4834437
Min length	1
Contains chars	True
Contains digits	True
Contains spaces	True
Contains non-words	True

host_acceptance_rate
Constant

This variable is constant and should be ignored for analysis

Constant value	nan

host_has_profile_pic
Boolean

Distinct count	2
Unique (%)	0.4%
Missing (%)	0.0%
Missing (n)	0

t	452
f	1

Toggle details

Value	Count	Frequency (%)
t	452	99.8%
f	1	0.2%

host_id
Numeric

Distinct count	381
Unique (%)	84.1%
Missing (%)	0.0%
Missing (n)	0
Infinite (%)	0.0%
Infinite (n)	0

Mean	1063003.311
Minimum	2217
Maximum	4059665
Zeros (%)	0.0%

Toggle details

Quantile statistics

Minimum	2217
5-th percentile	98237
Q1	611847
Median	1152791
Q3	1409188
95-th percentile	2040642.6
Maximum	4059665
Range	4057448
Interquartile range	797341

Descriptive statistics

Standard deviation	603446.6401
Coef of variation	0.5676808658
Kurtosis	0.5049375493
Mean	1063003.311
MAD	493770.993
Skewness	0.2487864693
Sum	481540500
Variance	3.641478474e+11
Memory size	3.6 KiB

Histogram with fixed size bins (bins=50)

Histogram with variable size bins (bins=[2.2170000e+03 3.1402700e+05 8.0605500e+05 9.8112300e+05 1.1951010e+06 ... 1.3916585e+06 1.3933665e+06 1.6802285e+06 2.2808840e+06 4.0596650e+06], "bayesian blocks" binning strategy used)

Value	Count	Frequency (%)
1391772	9	2.0%
1654885	5	1.1%
833995	4	0.9%
163384	4	0.9%
898681	4	0.9%
1311309	4	0.9%
1282150	4	0.9%
1310755	4	0.9%
1371414	3	0.7%
1473320	3	0.7%
Other values (371)	409	90.3%

Minimum 5 values

Value	Count	Frequency (%)
2217	1	0.2%
2986	1	0.2%
3718	1	0.2%
4108	1	0.2%
17391	1	0.2%

Maximum 5 values

Value	Count	Frequency (%)
4059665	1	0.2%
3062473	1	0.2%
2281237	1	0.2%
2280531	1	0.2%
2271792	1	0.2%

host_identity_verified
Boolean

Distinct count	2
Unique (%)	0.4%
Missing (%)	0.0%
Missing (n)	0

f	240
t	213

Toggle details

Value	Count	Frequency (%)
f	240	53.0%
t	213	47.0%

host_is_superhost
Boolean

Distinct count	2
Unique (%)	0.4%
Missing (%)	0.0%
Missing (n)	0

f	347
t	106

Toggle details

Value	Count	Frequency (%)
f	347	76.6%
t	106	23.4%

host_listings_count
Highly correlated

This variable is highly correlated with calculated_host_listings_count and should be ignored for analysis

Correlation	0.969958062

host_location
Categorical

Distinct count	33
Unique (%)	7.3%
Missing (%)	0.0%
Missing (n)	0

Berlin, Berlin, Germany	410
DE	4
Germany	4
Other values (30)	35

Toggle details

Common values
Composition

Value	Count	Frequency (%)
Berlin, Berlin, Germany	410	90.5%
DE	4	0.9%
Germany	4	0.9%
Munich, Bayern, Germany	3	0.7%
Plombières, Walloon Region, Belgium	2	0.4%
Santa Cruz, California, United States	2	0.4%
Ibiza, Balearic Islands, Spain	2	0.4%
Kansas City, Kansas, United States	1	0.2%
Key Biscayne, Florida, United States	1	0.2%
Hamburg, Hamburg, Germany	1	0.2%
Other values (23)	23	5.1%

Max length	55
Mean length	23.11479029
Min length	2
Contains chars	True
Contains digits	False
Contains spaces	True
Contains non-words	True

host_name
Categorical

Distinct count	317
Unique (%)	70.0%
Missing (%)	0.0%
Missing (n)	0

Sunflower Hostel	9
Peter	6
Michael	6
Other values (314)	432

Toggle details

Common values
Composition

Value	Count	Frequency (%)
Sunflower Hostel	9	2.0%
Peter	6	1.3%
Michael	6	1.3%
Bernd	6	1.3%
Claudius	5	1.1%
Ursula	5	1.1%
Frank	5	1.1%
Wolfram	5	1.1%
Alexander	4	0.9%
Ilona	4	0.9%
Other values (307)	398	87.9%

Max length	22
Mean length	6.536423841
Min length	1
Contains chars	True
Contains digits	False
Contains spaces	True
Contains non-words	True

host_neighbourhood
Categorical

Distinct count	49
Unique (%)	10.8%
Missing (%)	0.0%
Missing (n)	0

Prenzlauer Berg	88
Mitte	65
Kreuzberg	58
Other values (46)	242

Toggle details

Common values
Composition

Value	Count	Frequency (%)
Prenzlauer Berg	88	19.4%
Mitte	65	14.3%
Kreuzberg	58	12.8%
Friedrichshain	47	10.4%
Neukölln	34	7.5%
Schöneberg	31	6.8%
Charlottenburg	27	6.0%
Moabit	11	2.4%
Wilmersdorf	9	2.0%
Wedding	7	1.5%
Other values (39)	76	16.8%

Max length	17
Mean length	10.47019868
Min length	5
Contains chars	True
Contains digits	False
Contains spaces	True
Contains non-words	True

host_picture_url
URL

Distinct count	381
Unique (%)	84.1%
Missing (%)	0.0%
Missing (n)	0

Toggle details

Value	Count	Frequency (%)
https://a0.muscache.com/im/users/1391772/profile_pic/1399369623/original.jpg?aki_policy=profile_x_medium	9	2.0%
https://a0.muscache.com/im/users/1654885/profile_pic/1428655180/original.jpg?aki_policy=profile_x_medium	5	1.1%
https://a0.muscache.com/im/users/833995/profile_pic/1311108238/original.jpg?aki_policy=profile_x_medium	4	0.9%
https://a0.muscache.com/im/users/1282150/profile_pic/1390041405/original.jpg?aki_policy=profile_x_medium	4	0.9%
https://a0.muscache.com/im/users/163384/profile_pic/1284286874/original.jpg?aki_policy=profile_x_medium	4	0.9%
https://a0.muscache.com/im/users/1311309/profile_pic/1319105126/original.jpg?aki_policy=profile_x_medium	4	0.9%
https://a0.muscache.com/im/users/898681/profile_pic/1391541551/original.jpg?aki_policy=profile_x_medium	4	0.9%
https://a0.muscache.com/im/users/1310755/profile_pic/1319620911/original.jpg?aki_policy=profile_x_medium	4	0.9%
https://a0.muscache.com/im/users/1354122/profile_pic/1320067999/original.jpg?aki_policy=profile_x_medium	3	0.7%
https://a0.muscache.com/im/users/1848347/profile_pic/1330987898/original.jpg?aki_policy=profile_x_medium	3	0.7%
Other values (371)	409	90.3%

Value	Count	Frequency (%)
https	453	100.0%

Value	Count	Frequency (%)
a0.muscache.com	453	100.0%

Value	Count	Frequency (%)
/im/users/1391772/profile_pic/1399369623/original.jpg	9	2.0%
/im/users/1654885/profile_pic/1428655180/original.jpg	5	1.1%
/im/users/163384/profile_pic/1284286874/original.jpg	4	0.9%
/im/users/833995/profile_pic/1311108238/original.jpg	4	0.9%
/im/users/898681/profile_pic/1391541551/original.jpg	4	0.9%
/im/users/1310755/profile_pic/1319620911/original.jpg	4	0.9%
/im/users/1311309/profile_pic/1319105126/original.jpg	4	0.9%
/im/users/1282150/profile_pic/1390041405/original.jpg	4	0.9%
/im/users/1371414/profile_pic/1320450499/original.jpg	3	0.7%
/im/users/1968246/profile_pic/1332173070/original.jpg	3	0.7%
Other values (371)	409	90.3%

Value	Count	Frequency (%)
aki_policy=profile_x_medium	452	99.8%
v=3	1	0.2%

Value	Count	Frequency (%)
	453	100.0%

host_response_rate
Categorical

Distinct count	22
Unique (%)	4.9%
Missing (%)	40.4%
Missing (n)	183

100%	213
90%	13
86%	7
Other values (18)	37
(Missing)	183

Toggle details

Common values
Composition

Value	Count	Frequency (%)
100%	213	47.0%
90%	13	2.9%
86%	7	1.5%
50%	6	1.3%
80%	5	1.1%
75%	4	0.9%
0%	3	0.7%
96%	3	0.7%
95%	2	0.4%
88%	2	0.4%
Other values (11)	12	2.6%
(Missing)	183	40.4%

Max length	4
Mean length	3.463576159
Min length	2
Contains chars	True
Contains digits	True
Contains spaces	False
Contains non-words	True

host_response_time
Categorical

Distinct count	5
Unique (%)	1.1%
Missing (%)	40.4%
Missing (n)	183

within an hour	118
within a few hours	78
within a day	68
(Missing)	183

Toggle details

Common values
Composition

Value	Count	Frequency (%)
within an hour	118	26.0%
within a few hours	78	17.2%
within a day	68	15.0%
a few days or more	6	1.3%
(Missing)	183	40.4%

Max length	18
Mean length	9.997792494
Min length	3
Contains chars	True
Contains digits	False
Contains spaces	True
Contains non-words	True

host_since
Categorical

Distinct count	275
Unique (%)	60.7%
Missing (%)	0.0%
Missing (n)	0

2011-10-19	14
2011-11-10	10
2011-10-11	7
Other values (272)	422

Toggle details

Common values
Composition

Value	Count	Frequency (%)
2011-10-19	14	3.1%
2011-11-10	10	2.2%
2011-10-11	7	1.5%
2012-01-26	7	1.5%
2011-10-24	5	1.1%
2011-07-31	5	1.1%
2011-07-18	5	1.1%
2011-10-14	5	1.1%
2011-10-31	5	1.1%
2011-09-22	5	1.1%
Other values (265)	385	85.0%

Max length	10
Mean length	10
Min length	10
Contains chars	False
Contains digits	True
Contains spaces	False
Contains non-words	True

host_thumbnail_url
URL

Distinct count	381
Unique (%)	84.1%
Missing (%)	0.0%
Missing (n)	0

Toggle details

Value	Count	Frequency (%)
https://a0.muscache.com/im/users/1391772/profile_pic/1399369623/original.jpg?aki_policy=profile_small	9	2.0%
https://a0.muscache.com/im/users/1654885/profile_pic/1428655180/original.jpg?aki_policy=profile_small	5	1.1%
https://a0.muscache.com/im/users/1311309/profile_pic/1319105126/original.jpg?aki_policy=profile_small	4	0.9%
https://a0.muscache.com/im/users/163384/profile_pic/1284286874/original.jpg?aki_policy=profile_small	4	0.9%
https://a0.muscache.com/im/users/1282150/profile_pic/1390041405/original.jpg?aki_policy=profile_small	4	0.9%
https://a0.muscache.com/im/users/1310755/profile_pic/1319620911/original.jpg?aki_policy=profile_small	4	0.9%
https://a0.muscache.com/im/users/898681/profile_pic/1391541551/original.jpg?aki_policy=profile_small	4	0.9%
https://a0.muscache.com/im/users/833995/profile_pic/1311108238/original.jpg?aki_policy=profile_small	4	0.9%
https://a0.muscache.com/im/users/1473320/profile_pic/1323093790/original.jpg?aki_policy=profile_small	3	0.7%
https://a0.muscache.com/im/users/1848347/profile_pic/1330987898/original.jpg?aki_policy=profile_small	3	0.7%
Other values (371)	409	90.3%

Value	Count	Frequency (%)
https	453	100.0%

Value	Count	Frequency (%)
a0.muscache.com	453	100.0%

Value	Count	Frequency (%)
/im/users/1391772/profile_pic/1399369623/original.jpg	9	2.0%
/im/users/1654885/profile_pic/1428655180/original.jpg	5	1.1%
/im/users/1311309/profile_pic/1319105126/original.jpg	4	0.9%
/im/users/1310755/profile_pic/1319620911/original.jpg	4	0.9%
/im/users/833995/profile_pic/1311108238/original.jpg	4	0.9%
/im/users/898681/profile_pic/1391541551/original.jpg	4	0.9%
/im/users/163384/profile_pic/1284286874/original.jpg	4	0.9%
/im/users/1282150/profile_pic/1390041405/original.jpg	4	0.9%
/im/users/253136/profile_pic/1331586983/original.jpg	3	0.7%
/im/users/1848347/profile_pic/1330987898/original.jpg	3	0.7%
Other values (371)	409	90.3%

Value	Count	Frequency (%)
aki_policy=profile_small	452	99.8%
v=3	1	0.2%

Value	Count	Frequency (%)
	453	100.0%

host_total_listings_count
Highly correlated

This variable is highly correlated with host_listings_count and should be ignored for analysis

Correlation	1

host_url
URL

Distinct count	381
Unique (%)	84.1%
Missing (%)	0.0%
Missing (n)	0

Toggle details

Value	Count	Frequency (%)
https://www.airbnb.com/users/show/1391772	9	2.0%
https://www.airbnb.com/users/show/1654885	5	1.1%
https://www.airbnb.com/users/show/1310755	4	0.9%
https://www.airbnb.com/users/show/1311309	4	0.9%
https://www.airbnb.com/users/show/898681	4	0.9%
https://www.airbnb.com/users/show/833995	4	0.9%
https://www.airbnb.com/users/show/1282150	4	0.9%
https://www.airbnb.com/users/show/163384	4	0.9%
https://www.airbnb.com/users/show/1328326	3	0.7%
https://www.airbnb.com/users/show/253136	3	0.7%
Other values (371)	409	90.3%

Value	Count	Frequency (%)
https	453	100.0%

Value	Count	Frequency (%)
www.airbnb.com	453	100.0%

Value	Count	Frequency (%)
/users/show/1391772	9	2.0%
/users/show/1654885	5	1.1%
/users/show/898681	4	0.9%
/users/show/1282150	4	0.9%
/users/show/163384	4	0.9%
/users/show/1310755	4	0.9%
/users/show/1311309	4	0.9%
/users/show/833995	4	0.9%
/users/show/1848347	3	0.7%
/users/show/1473320	3	0.7%
Other values (371)	409	90.3%

Value	Count	Frequency (%)
	453	100.0%

Value	Count	Frequency (%)
	453	100.0%

host_verifications
Categorical

Distinct count	55
Unique (%)	12.1%
Missing (%)	0.0%
Missing (n)	0

['email', 'phone', 'reviews']	92
['email', 'phone', 'reviews', 'jumio', 'government_id']	56
['email', 'phone', 'facebook', 'reviews', 'jumio', 'government_id']	37
Other values (52)	268

Toggle details

Common values
Composition

Value	Count	Frequency (%)
['email', 'phone', 'reviews']	92	20.3%
['email', 'phone', 'reviews', 'jumio', 'government_id']	56	12.4%
['email', 'phone', 'facebook', 'reviews', 'jumio', 'government_id']	37	8.2%
['email', 'phone', 'facebook', 'reviews']	35	7.7%
['email', 'phone', 'reviews', 'jumio', 'offline_government_id', 'government_id']	34	7.5%
['email', 'phone', 'reviews', 'jumio', 'offline_government_id', 'selfie', 'government_id', 'identity_manual']	29	6.4%
['email', 'phone', 'reviews', 'kba']	19	4.2%
['email', 'phone', 'facebook', 'reviews', 'jumio', 'offline_government_id', 'government_id']	15	3.3%
['email', 'phone', 'reviews', 'jumio', 'government_id', 'work_email']	12	2.6%
['email', 'phone', 'facebook', 'reviews', 'jumio', 'offline_government_id', 'selfie', 'government_id', 'identity_manual']	11	2.4%
Other values (45)	113	24.9%

Max length	156
Mean length	63.81677704
Min length	18
Contains chars	True
Contains digits	False
Contains spaces	True
Contains non-words	True

house_rules
Categorical

Distinct count	325
Unique (%)	71.7%
Missing (%)	25.2%
Missing (n)	114

Handtücher und Bettwäsche können für 5 € pro Person gemietet werden, sonst bitte mitbringen.	3
Please note that smoking is strictly forbidden.	2
- Allergikergeeignet, Haustiere nicht gestattet, Nichtraucher - Sämtliche Preise beinhalten die Kosten für Endreinigung, Handtücher und Bettwäsche. Sonderpreise ab 8 Übernachtungen auf Anfrage - Fahrräder können je nach Verfügbarkeit für 5,00 €/ Tag gemietet werden. - Suitable for allergy sufferers, no pets, Non smoking - All prices include the cost of cleaning, towels and bed linen. Special rates from 8 nights on request - Bicycles can be rented depending on availability for 5.00 € / day.	2
Other values (321)	332
(Missing)	114

Toggle details

Common values
Composition

Value	Count	Frequency (%)
Handtücher und Bettwäsche können für 5 € pro Person gemietet werden, sonst bitte mitbringen.	3	0.7%
Please note that smoking is strictly forbidden.	2	0.4%
- Allergikergeeignet, Haustiere nicht gestattet, Nichtraucher - Sämtliche Preise beinhalten die Kosten für Endreinigung, Handtücher und Bettwäsche. Sonderpreise ab 8 Übernachtungen auf Anfrage - Fahrräder können je nach Verfügbarkeit für 5,00 €/ Tag gemietet werden. - Suitable for allergy sufferers, no pets, Non smoking - All prices include the cost of cleaning, towels and bed linen. Special rates from 8 nights on request - Bicycles can be rented depending on availability for 5.00 € / day.	2	0.4%
Bitte aus Rücksicht auf die nachfolgende Gäste in der Wohnung nicht rauchen. Wenn es die Belegung zulässt, können Sie gern auch schon früh am Morgen anreisen und abends abreisen. Und noch eine Bitte: Da es sich um ein älteres Haus handelt und sehr hellhörig ist, bitte abends nach 22 Uhr Gespräche nur noch in Zimmerlautstärke führen. Vielen Dank im Namen unserer Mieter und Gäste.	2	0.4%
HAUSORDNUNG HERZLICH WILLKOMMEN IN DER FERIENWOHNUNG DRESSLER DEM FERIENHAUS / FERIENWOHNUNG DRESSLER AM WASSER VOR ORT ENTFALLEN ZUSÄTZLICHE GEBÜHREN FÜR STROM 0,25 € / Kwh , WASSER 5,00 € / m³ , HEIZUNG 0,06 € x (Phone number hidden by Airbnb) / m³, CITY TAX 5% VOM MIETPREIS UND WIFI 3,00 € / TAG ( OPTIONAL ) UM EINEN REIBUNGSLOSEN ABLAUF IHRES URLAUBES ZU GARANTIEREN MÖCHTEN WIR UNSERE GÄSTE HÖFLICHST BITTEN, SICH AN DIE FOLGENDE HAUSORDNUNG ZU HALTEN DAS INVENTAR IST SORGFÄLTIG ZU BEHANDELN DAS RAUCHEN IN DER FERIENWOHNUNG IST VERBOTEN UNBEDINGT IST DIE NACHTRUHE EINZUHALTEN – AB (Phone number hidden by Airbnb) SIND FERNSEHER UND MUSIKANLAGE AUF ZIMMERLAUTSTÄRKE ZU BETREIBEN BITTE SCHLIESSEN SIE DIE FENSTER UND TERASSEN / BALKON TÜREN BEIM VERLASSEN DER WOHNUNG DER FEUERLÖSCHER BEFINDET SICH IM EINGANGSBEREICH DIE HAUSTÜR IST GRUNDSÄTZLICH BEIM VERLASSEN ZU VERRIEGELN DIE RAUCHMELDER SIND ÖFTERS AUF FUNKTIONALITÄT ZU KONTROLLIEREN DIE ZIMMERPFLANZEN SIND ALLE 4 TAGE ZU GIESSE	2	0.4%
Checkin 15 -18 h/3-6 pm. Checkout bis/until 11 h/11 am. Zusätzlich zum Mietpreis fällt 5% City Tax für private Reisen an. Additional to the accomodation price is 5% City Tax payable for private traveling. Garagenplatz 5 €/Nacht, Parking 5 €/night.	2	0.4%
BITTE BEACHTEN SIE DIES: Seien Sie sich bewusst, dass sich die Wohnung in einem Wohnhaus befindet und keine lauten Feiern erlaubt sind. Bitte seien Sie während Ihres Aufenthaltes so ruhig wie möglich, besonders von 22:00 bis 8:00. PLEASE NOTE THESE RULES: Be aware that the apartment is located in a residential building and no partying is tolerated. Please be as quiet as possible during your stay, especially from 10:00pm to 08:00am.	2	0.4%
* Do not make noise / play music etc after 10 pm or between noon and 2 pm. * Please close the windows after 10 pm when you are having a loud conversation. Noise carries and will disturb other neighbours. * Please also try to be quiet when returning home late. * Partying is not allowed in the apartment and reason for immediate cancellation of the rental contract. * The apartment may only be used by the named guests. The usage by a third party or any other additional occupancy is not permitted. * Smoking is prohibited anywhere in the building. Violation of this rule will result in a 100 EUR fine which will be subtracted from your deposit. You may use the backyard to smoke. * Please do not wear street shoes in the apartment. * We wash and dry bedding and towels in the apartment. During your stay we may be drying clothes on a rack inside the apartment. Please do not use these towels or bedding. They are not for you, they are for the next guests. * ILLEGAL DOWNLOADING or viewing of ille	2	0.4%
No smoking, loud music or hosting parties at the apartment.	2	0.4%
Smoking is only allowed in the kitchen and living room.	2	0.4%
Other values (314)	318	70.2%
(Missing)	114	25.2%

Max length	1000
Mean length	286.4260486
Min length	3
Contains chars	True
Contains digits	True
Contains spaces	True
Contains non-words	True

id
Numeric

Distinct count	453
Unique (%)	100.0%
Missing (%)	0.0%
Missing (n)	0
Infinite (%)	0.0%
Infinite (n)	0

Mean	230823.2009
Minimum	2015
Maximum	466983
Zeros (%)	0.0%

Toggle details

Quantile statistics

Minimum	2015
5-th percentile	29888.6
Q1	169603
Median	244425
Q3	306312
95-th percentile	428583.2
Maximum	466983
Range	464968
Interquartile range	136709

Descriptive statistics

Standard deviation	114502.2697
Coef of variation	0.4960604882
Kurtosis	-0.5576514297
Mean	230823.2009
MAD	90695.30055
Skewness	-0.1318743799
Sum	104562910
Variance	1.311076977e+10
Memory size	3.6 KiB

Histogram with fixed size bins (bins=50)

Histogram with variable size bins (bins=[ 2015. 64417.5 169109. 250015. 250741. 265371.5 265438.5 323246.5 323259.5 466983. ], "bayesian blocks" binning strategy used)

Value	Count	Frequency (%)
306829	1	0.2%
307587	1	0.2%
306502	1	0.2%
265402	1	0.2%
261452	1	0.2%
177486	1	0.2%
439631	1	0.2%
323920	1	0.2%
358746	1	0.2%
149849	1	0.2%
Other values (443)	443	97.8%

Minimum 5 values

Value	Count	Frequency (%)
2015	1	0.2%
2695	1	0.2%
3176	1	0.2%
3309	1	0.2%
7071	1	0.2%

Maximum 5 values

Value	Count	Frequency (%)
466983	1	0.2%
464324	1	0.2%
462459	1	0.2%
458800	1	0.2%
458608	1	0.2%

instant_bookable
Boolean

Distinct count	2
Unique (%)	0.4%
Missing (%)	0.0%
Missing (n)	0

f	337
t	116

Toggle details

Value	Count	Frequency (%)
f	337	74.4%
t	116	25.6%

interaction
Categorical

Distinct count	195
Unique (%)	43.0%
Missing (%)	52.3%
Missing (n)	237

You will be welcomed by our friendly and open Staff, who will help you with good advices and guarantee a great stay in our hostel.	9
Wir wohnen im gleichen Haus, das macht die Kommunikation sehr einfach.	3
Bei Problemen und Fragen bin ich immer erreichbar.	3
Other values (191)	201
(Missing)	237

Toggle details

Common values
Composition

Value	Count	Frequency (%)
You will be welcomed by our friendly and open Staff, who will help you with good advices and guarantee a great stay in our hostel.	9	2.0%
Wir wohnen im gleichen Haus, das macht die Kommunikation sehr einfach.	3	0.7%
Bei Problemen und Fragen bin ich immer erreichbar.	3	0.7%
Gerne stehe ich für allerlei Informationen bereit und gebe auch gerne "Insidertipps" und versuche euch jede Frage zu beantworten... - Wo gibt es die beste Pho Bo? Welches Restaurant sollte man meiden? Wo kann ich am Dienstag Abend Jazz lauschen? Wo gibt es Kunst umsonst? Wo muss ich Fotos machen? Welche Club geht, welcher geht gar nicht? Was ist typisch Friedrichshain?	2	0.4%
Henning Wulff und Denis Stephan	2	0.4%
Mail, SMS, Telefon	2	0.4%
Frågor? Jag försöker att svara och lösa de flesta frågor som mina gäster har. Det finns inga problem, bara lösningar ....	2	0.4%
I leave my guests free space, but I am available for questions.	2	0.4%
The guest determines how much interaction they want. We do greet them on arrival and answer all of their questions and then can be reached by phone at any reasonable hour.	2	0.4%
We can be contacted on our cell phones if a guest needs help	2	0.4%
Other values (184)	187	41.3%
(Missing)	237	52.3%

Max length	1000
Mean length	72.18763797
Min length	3
Contains chars	True
Contains digits	True
Contains spaces	True
Contains non-words	True

is_business_travel_ready
Constant

This variable is constant and should be ignored for analysis

Constant value	f

is_location_exact
Boolean

Distinct count	2
Unique (%)	0.4%
Missing (%)	0.0%
Missing (n)	0

t	415
f	38

Toggle details

Value	Count	Frequency (%)
t	415	91.6%
f	38	8.4%

jurisdiction_names
Constant

This variable is constant and should be ignored for analysis

Constant value	nan

last_review
Categorical

Distinct count	218
Unique (%)	48.1%
Missing (%)	3.5%
Missing (n)	16

2018-11-04	18
2018-10-14	14
2018-10-31	12
Other values (214)	393
(Missing)	16

Toggle details

Common values
Composition

Value	Count	Frequency (%)
2018-11-04	18	4.0%
2018-10-14	14	3.1%
2018-10-31	12	2.6%
2018-11-03	10	2.2%
2018-10-24	9	2.0%
2018-10-21	9	2.0%
2018-10-30	9	2.0%
2018-11-05	8	1.8%
2018-10-29	8	1.8%
2018-10-28	7	1.5%
Other values (207)	333	73.5%
(Missing)	16	3.5%

Max length	10
Mean length	9.752759382
Min length	3
Contains chars	True
Contains digits	True
Contains spaces	False
Contains non-words	True

last_scraped
Constant

This variable is constant and should be ignored for analysis

Constant value	2018-11-07

latitude
Numeric

Distinct count	453
Unique (%)	100.0%
Missing (%)	0.0%
Missing (n)	0
Infinite (%)	0.0%
Infinite (n)	0

Mean	52.51074992
Minimum	52.37827969
Maximum	52.62708837
Zeros (%)	0.0%

Toggle details

Quantile statistics

Minimum	52.37827969
5-th percentile	52.44305074
Q1	52.49449572
Median	52.51109473
Q3	52.53284934
95-th percentile	52.5517375
Maximum	52.62708837
Range	0.2488086812
Interquartile range	0.03835362111

Descriptive statistics

Standard deviation	0.03468644112
Coef of variation	0.0006605588602
Kurtosis	2.58203623
Mean	52.51074992
MAD	0.02531851971
Skewness	-0.8053213985
Sum	23787.36971
Variance	0.001203149197
Memory size	3.6 KiB

Histogram with fixed size bins (bins=50)

Histogram with variable size bins (bins=[52.37827969 52.4754785 52.48799616 52.51329724 52.52748711 52.54413527 52.55258389 52.62708837], "bayesian blocks" binning strategy used)

Value	Count	Frequency (%)
52.54968096	1	0.2%
52.49847237	1	0.2%
52.51654715	1	0.2%
52.54250549	1	0.2%
52.54062968	1	0.2%
52.5181772	1	0.2%
52.47587686	1	0.2%
52.43510474	1	0.2%
52.50329385	1	0.2%
52.54385541	1	0.2%
Other values (443)	443	97.8%

Minimum 5 values

Value	Count	Frequency (%)
52.37827969	1	0.2%
52.3787808	1	0.2%
52.37886768	1	0.2%
52.38057986	1	0.2%
52.39178909	1	0.2%

Maximum 5 values

Value	Count	Frequency (%)
52.62708837	1	0.2%
52.60825279	1	0.2%
52.60326604	1	0.2%
52.59656149	1	0.2%
52.59403928	1	0.2%

license
Categorical

Distinct count	100
Unique (%)	22.1%
Missing (%)	77.3%
Missing (n)	350

0 gewerblich	3
AF/000106-14	2
Gewerbe!	2
Other values (96)	96
(Missing)	350

Toggle details

Common values
Composition

Value	Count	Frequency (%)
0 gewerblich	3	0.7%
AF/000106-14	2	0.4%
Gewerbe!	2	0.4%
07/Z/ZA/001832-16	1	0.2%
03/Z/AZ/003833-18	1	0.2%
DE250645704	1	0.2%
07/Z/ZE/005361-18	1	0.2%
Wohn II-ZW 2-02/Z/ZA/001717-15	1	0.2%
03/Z/RA/003410-18	1	0.2%
07/Z/ZE/003727-17	1	0.2%
Other values (89)	89	19.6%
(Missing)	350	77.3%

Max length	89
Mean length	6.441501104
Min length	3
Contains chars	True
Contains digits	True
Contains spaces	True
Contains non-words	True

listing_url
URL

Distinct count	453
Unique (%)	100.0%
Missing (%)	0.0%
Missing (n)	0

Toggle details

Value	Count	Frequency (%)
https://www.airbnb.com/rooms/151249	1	0.2%
https://www.airbnb.com/rooms/282214	1	0.2%
https://www.airbnb.com/rooms/370561	1	0.2%
https://www.airbnb.com/rooms/83183	1	0.2%
https://www.airbnb.com/rooms/38074	1	0.2%
https://www.airbnb.com/rooms/458586	1	0.2%
https://www.airbnb.com/rooms/256058	1	0.2%
https://www.airbnb.com/rooms/304904	1	0.2%
https://www.airbnb.com/rooms/244425	1	0.2%
https://www.airbnb.com/rooms/194694	1	0.2%
Other values (443)	443	97.8%

Value	Count	Frequency (%)
https	453	100.0%

Value	Count	Frequency (%)
www.airbnb.com	453	100.0%

Value	Count	Frequency (%)
/rooms/321295	1	0.2%
/rooms/245991	1	0.2%
/rooms/143605	1	0.2%
/rooms/242908	1	0.2%
/rooms/410020	1	0.2%
/rooms/281152	1	0.2%
/rooms/42742	1	0.2%
/rooms/233453	1	0.2%
/rooms/393598	1	0.2%
/rooms/87549	1	0.2%
Other values (443)	443	97.8%

Value	Count	Frequency (%)
	453	100.0%

Value	Count	Frequency (%)
	453	100.0%

longitude
Numeric

Distinct count	453
Unique (%)	100.0%
Missing (%)	0.0%
Missing (n)	0
Infinite (%)	0.0%
Infinite (n)	0

Mean	13.40058422
Minimum	13.16417768
Maximum	13.65278723
Zeros (%)	0.0%

Toggle details

Quantile statistics

Minimum	13.16417768
5-th percentile	13.29638914
Q1	13.37267708
Median	13.41118504
Q3	13.43205992
95-th percentile	13.47066402
Maximum	13.65278723
Range	0.4886095444
Interquartile range	0.05938284159

Descriptive statistics

Standard deviation	0.06289275209
Coef of variation	0.004693284342
Kurtosis	3.231561664
Mean	13.40058422
MAD	0.04461159739
Skewness	-0.05946621513
Sum	6070.464651
Variance	0.003955498265
Memory size	3.6 KiB

Histogram with fixed size bins (bins=50)

Histogram with variable size bins (bins=[13.16417768 13.29100369 13.36046118 13.38150305 13.40351508 13.42973709 13.47190485 13.65119412 13.65278723], "bayesian blocks" binning strategy used)

Value	Count	Frequency (%)
13.41705422	1	0.2%
13.36466023	1	0.2%
13.41603795	1	0.2%
13.29651397	1	0.2%
13.42852671	1	0.2%
13.38847176	1	0.2%
13.40286718	1	0.2%
13.44377284	1	0.2%
13.42814429	1	0.2%
13.43719326	1	0.2%
Other values (443)	443	97.8%

Minimum 5 values

Value	Count	Frequency (%)
13.16417768	1	0.2%
13.1644643	1	0.2%
13.17573477	1	0.2%
13.21214126	1	0.2%
13.22265649	1	0.2%

Maximum 5 values

Value	Count	Frequency (%)
13.65278723	1	0.2%
13.65275115	1	0.2%
13.65123141	1	0.2%
13.65115684	1	0.2%
13.63528316	1	0.2%

market
Constant

This variable is constant and should be ignored for analysis

Constant value	Berlin

maximum_nights
Numeric

Distinct count	71
Unique (%)	15.7%
Missing (%)	0.0%
Missing (n)	0
Infinite (%)	0.0%
Infinite (n)	0

Mean	367.5827815
Minimum	3
Maximum	2000
Zeros (%)	0.0%

Toggle details

Quantile statistics

Minimum	3
5-th percentile	13.6
Q1	31
Median	360
Q3	365
95-th percentile	1125
Maximum	2000
Range	1997
Interquartile range	334

Descriptive statistics

Standard deviation	401.0065106
Coef of variation	1.090928441
Kurtosis	0.3317310345
Mean	367.5827815
MAD	303.7272634
Skewness	1.15757878
Sum	166515
Variance	160806.2216
Memory size	3.6 KiB

Histogram with fixed size bins (bins=50)

Histogram with variable size bins (bins=[ 3. 13.5 15.5 19.5 21.5 ... 726.5 745. 1122. 1162.5 2000. ], "bayesian blocks" binning strategy used)

Value	Count	Frequency (%)
365	118	26.0%
1125	62	13.7%
30	33	7.3%
60	30	6.6%
90	17	3.8%
730	15	3.3%
21	14	3.1%
14	13	2.9%
360	10	2.2%
180	9	2.0%
Other values (61)	132	29.1%

Minimum 5 values

Value	Count	Frequency (%)
3	1	0.2%
4	2	0.4%
5	1	0.2%
6	2	0.4%
7	6	1.3%

Maximum 5 values

Value	Count	Frequency (%)
2000	1	0.2%
1825	1	0.2%
1200	1	0.2%
1125	62	13.7%
1124	4	0.9%

medium_url
Constant

This variable is constant and should be ignored for analysis

Constant value	nan

minimum_nights
Numeric

Distinct count	29
Unique (%)	6.4%
Missing (%)	0.0%
Missing (n)	0
Infinite (%)	0.0%
Infinite (n)	0

Mean	16.29139073
Minimum	1
Maximum	270
Zeros (%)	0.0%

Toggle details

Quantile statistics

Minimum	1
5-th percentile	1
Q1	2
Median	3
Q3	6
95-th percentile	90
Maximum	270
Range	269
Interquartile range	4

Descriptive statistics

Standard deviation	33.20743121
Coef of variation	2.038342322
Kurtosis	13.83717662
Mean	16.29139073
MAD	21.41768636
Skewness	3.292859221
Sum	7380
Variance	1102.733488
Memory size	3.6 KiB

Histogram with fixed size bins (bins=29)

Histogram with variable size bins (bins=[ 1. 3.5 5.5 7.5 14.5 ... 59. 61. 87.5 90.5 270. ], "bayesian blocks" binning strategy used)

Value	Count	Frequency (%)
2	116	25.6%
3	103	22.7%
1	55	12.1%
5	33	7.3%
4	32	7.1%
60	29	6.4%
90	16	3.5%
7	10	2.2%
30	10	2.2%
62	7	1.5%
Other values (19)	42	9.3%

Minimum 5 values

Value	Count	Frequency (%)
1	55	12.1%
2	116	25.6%
3	103	22.7%
4	32	7.1%
5	33	7.3%

Maximum 5 values

Value	Count	Frequency (%)
270	1	0.2%
183	1	0.2%
180	4	0.9%
150	1	0.2%
120	2	0.4%

monthly_price
Categorical

Distinct count	113
Unique (%)	24.9%
Missing (%)	43.0%
Missing (n)	195

$1,200.00	17
$1,500.00	11
$1,000.00	10
Other values (109)	220
(Missing)	195

Toggle details

Common values
Composition

Value	Count	Frequency (%)
$1,200.00	17	3.8%
$1,500.00	11	2.4%
$1,000.00	10	2.2%
$1,400.00	10	2.2%
$900.00	10	2.2%
$1,100.00	8	1.8%
$1,300.00	7	1.5%
$750.00	6	1.3%
$600.00	6	1.3%
$800.00	6	1.3%
Other values (102)	167	36.9%
(Missing)	195	43.0%

Max length	9
Mean length	5.962472406
Min length	3
Contains chars	True
Contains digits	True
Contains spaces	False
Contains non-words	True

name
Categorical

Distinct count	452
Unique (%)	99.8%
Missing (%)	0.0%
Missing (n)	0

Apartment in the heart of Berlin	2
Baroqueapartment with loftcharacter	1
Beautiful 1-room apartment	1
Other values (449)	449

Toggle details

Common values
Composition

Value	Count	Frequency (%)
Apartment in the heart of Berlin	2	0.4%
Baroqueapartment with loftcharacter	1	0.2%
Beautiful 1-room apartment	1	0.2%
Berlin City Center, Great Vista	1	0.2%
Apollo Apartments 1	1	0.2%
STUDIO NEAR KASTANIENALLE	1	0.2%
In the middle of Mitte and green!	1	0.2%
Central Kreuzberg apartment	1	0.2%
Central Artist Appartement Prenzlauer Berg	1	0.2%
2,5 Room Apartment in Neukölln, Berlin	1	0.2%
Other values (442)	442	97.6%

Max length	71
Mean length	32.9183223
Min length	9
Contains chars	True
Contains digits	True
Contains spaces	True
Contains non-words	True

neighborhood_overview
Categorical

Distinct count	220
Unique (%)	48.6%
Missing (%)	46.6%
Missing (n)	211

Home of this pretty accommodation is Friedrichshain, one of the central districs in Berlin, surrounded by Prenzlauer Berg, Mitte and Kreuzberg. Friedrichshain distinguishes himself as a student and artist district by its young and creative activities. Primarily due to the numerous bars, cafes, restaurants, galleries, theaters and cultural institutions with many really cheap small meal occasions with specialties from around the world. In addition, there's the spectacular collection of Berlin's best clubs, which are in large part all within walking distance. Because in 200 meters distance, among other things, there is the Berghain / Panorama Bar, which was chosen not only by the New York Times as the "best club in the world".	9
Die Unterkünfte liegen im Bezirk Neukölln mitten im 1737 gegründeten historischen Arbeiterviertel Böhmisch-Rixdorf. In unmittelbarer Umgebung: Cafés, Bars, Einkaufsmöglichkeiten, Neuköllner Oper, Kinos, zahlreiche Galerien, Volkspark Hasenheide und Tempelhofer Feld. In Berlin bieten sich zahlreiche Möglichkeiten, historische und moderne Kultur besuchen, sich zu erholen, das Zusammenwachsen von Ost und West intensiv und lebendig erleben. Besondere Anziehungspunkten sind der historische Stadtkern mit dem Brandenburger Tor und der Straße unter den Linden sowie dem angrenzenden Regierungsviertel, einzigartige Museen, eine traditionsreiche Industriekultur, moderne Architektur oder die städtischen Naherholungsgebiete. Auf Wunsch gestalten wir Stadtführungen mit sachkundigen Stadtführern. Hierzu beraten wir Sie gern. Für Gruppen bis 8 Personen bieten wir Führungen für 20 Euro an, jede weitere Person 2 Euro. Die Nutzung des Berliner Nahverkehrs kostet extra.	5
In direkter Umgebung ist ein Supermarkt mit Bäcker, einige Clubs, Bars, Restaurants und Kino. Die Spree und ein großer Park sind auch in Laufweite.	3
Other values (216)	225
(Missing)	211

Toggle details

Common values
Composition

Value	Count	Frequency (%)
Home of this pretty accommodation is Friedrichshain, one of the central districs in Berlin, surrounded by Prenzlauer Berg, Mitte and Kreuzberg. Friedrichshain distinguishes himself as a student and artist district by its young and creative activities. Primarily due to the numerous bars, cafes, restaurants, galleries, theaters and cultural institutions with many really cheap small meal occasions with specialties from around the world. In addition, there's the spectacular collection of Berlin's best clubs, which are in large part all within walking distance. Because in 200 meters distance, among other things, there is the Berghain / Panorama Bar, which was chosen not only by the New York Times as the "best club in the world".	9	2.0%
Die Unterkünfte liegen im Bezirk Neukölln mitten im 1737 gegründeten historischen Arbeiterviertel Böhmisch-Rixdorf. In unmittelbarer Umgebung: Cafés, Bars, Einkaufsmöglichkeiten, Neuköllner Oper, Kinos, zahlreiche Galerien, Volkspark Hasenheide und Tempelhofer Feld. In Berlin bieten sich zahlreiche Möglichkeiten, historische und moderne Kultur besuchen, sich zu erholen, das Zusammenwachsen von Ost und West intensiv und lebendig erleben. Besondere Anziehungspunkten sind der historische Stadtkern mit dem Brandenburger Tor und der Straße unter den Linden sowie dem angrenzenden Regierungsviertel, einzigartige Museen, eine traditionsreiche Industriekultur, moderne Architektur oder die städtischen Naherholungsgebiete. Auf Wunsch gestalten wir Stadtführungen mit sachkundigen Stadtführern. Hierzu beraten wir Sie gern. Für Gruppen bis 8 Personen bieten wir Führungen für 20 Euro an, jede weitere Person 2 Euro. Die Nutzung des Berliner Nahverkehrs kostet extra.	5	1.1%
In direkter Umgebung ist ein Supermarkt mit Bäcker, einige Clubs, Bars, Restaurants und Kino. Die Spree und ein großer Park sind auch in Laufweite.	3	0.7%
There is a supermarket at the 1 floor of the building. The Apartment is located on Wilhelmstrasse. 2 blocks from Potsdamer Platz, the Berlin Wall and the Holocaust Memorial, also 3 blocks from the Brandenburg Gate and Check-Point Charlie. There are several restaurants just across the street. There's also the biggest shopping mall in Germany just across the street If you like bikes, there is a souvenir shop downstairs where you can also rent bikes for EUR 10.00 per day (the price may vary according to the shop owners decision)	2	0.4%
Despite the central location a very quiet street, in the vicinity are many cafes, restaurants and various supermarkets	2	0.4%
The apartment is located in the trendy, vibrant district of Prenzlauer Berg, bordering on artistic, cosmopolitan Mitte. The Oderberger Strasse is a very lively yet very relaxed street that offers the distinctively bohemian vibe Prenzlauer Berg has been made famous for. Artsy cafés, quaint boutiques and laid back restaurants make it a favourite destination of locals and visitors alike. Neighbourhood highlights include the Kastanienallee with its dozens of bars, restaurants and coffee shops -among which the renowned Prater, Berlin’s oldest beer garden- and the Mauerpark with its very popular Sunday flea market. The entertainment complex of the Kulturbrauerei is just around the corner, as well as the Kollwitzplatz with its fine wining and dining (and, of course, shopping). The not-to-be-missed Berlin Wall Memorial is in the vicinity of the apartments whereas Berlin landmarks such as the TV Tower or the Museum Island are a leisurely stroll. This is an ideal base for exploring Berlin: rig	2	0.4%
The neighbourhood is one of the coolest and hippest in all over Berlin - there are plenty of cafés, bars, restaurants, clubs and funky shops around. At one end of the street is the river Spree and the East Side Gallery, at the other there is Görlitzer Park.	2	0.4%
Här bor Du mitt i centrala Berlin direkt vid floden Spree, med 5 minuter till Skeppskajen för en båt- tur. Dessutom precis i kanten av Europas största park: Tiergarten; här han Du cykla, promenera och uppleva det mesta.	2	0.4%
Our Part of Kreuzberg is just the best. Good vibes, good stores, interesting people. What is there not to love :)	2	0.4%
Die Ruhe und die einmalige Lage des Ferienhauses Dressler am Wasser und der Ferienwohnung Dressler am Wasser sind einzigartig	2	0.4%
Other values (209)	211	46.6%
(Missing)	211	46.6%

Max length	1000
Mean length	227.4834437
Min length	3
Contains chars	True
Contains digits	True
Contains spaces	True
Contains non-words	True

neighbourhood
Categorical

Distinct count	48
Unique (%)	10.6%
Missing (%)	7.1%
Missing (n)	32

Prenzlauer Berg	83
Mitte	60
Kreuzberg	51
Other values (44)	227

Toggle details

Common values
Composition

Value	Count	Frequency (%)
Prenzlauer Berg	83	18.3%
Mitte	60	13.2%
Kreuzberg	51	11.3%
Friedrichshain	45	9.9%
Neukölln	33	7.3%
Schöneberg	28	6.2%
Charlottenburg	23	5.1%
Moabit	11	2.4%
Wedding	8	1.8%
Wilmersdorf	8	1.8%
Other values (37)	71	15.7%
(Missing)	32	7.1%

Max length	17
Mean length	9.958057395
Min length	3
Contains chars	True
Contains digits	False
Contains spaces	True
Contains non-words	True

neighbourhood_cleansed
Categorical

Distinct count	79
Unique (%)	17.4%
Missing (%)	0.0%
Missing (n)	0

Prenzlauer Berg Südwest	34
Brunnenstr. Süd	31
Frankfurter Allee Süd FK	29
Other values (76)	359

Toggle details

Common values
Composition

Value	Count	Frequency (%)
Prenzlauer Berg Südwest	34	7.5%
Brunnenstr. Süd	31	6.8%
Frankfurter Allee Süd FK	29	6.4%
Alexanderplatz	27	6.0%
Tempelhofer Vorstadt	23	5.1%
Helmholtzplatz	22	4.9%
Schöneberg-Nord	20	4.4%
südliche Luisenstadt	18	4.0%
Reuterstraße	17	3.8%
Prenzlauer Berg Süd	13	2.9%
Other values (69)	219	48.3%

Max length	41
Mean length	17.10596026
Min length	5
Contains chars	True
Contains digits	True
Contains spaces	True
Contains non-words	True

neighbourhood_group_cleansed
Categorical

Distinct count	12
Unique (%)	2.6%
Missing (%)	0.0%
Missing (n)	0

Friedrichshain-Kreuzberg	106
Pankow	101
Mitte	91
Other values (9)	155

Toggle details

Common values
Composition

Value	Count	Frequency (%)
Friedrichshain-Kreuzberg	106	23.4%
Pankow	101	22.3%
Mitte	91	20.1%
Neukölln	40	8.8%
Charlottenburg-Wilm.	39	8.6%
Tempelhof - Schöneberg	36	7.9%
Steglitz - Zehlendorf	12	2.6%
Treptow - Köpenick	12	2.6%
Reinickendorf	9	2.0%
Lichtenberg	4	0.9%
Other values (2)	3	0.7%

Max length	24
Mean length	13.63134658
Min length	5
Contains chars	True
Contains digits	False
Contains spaces	True
Contains non-words	True

notes
Categorical

Distinct count	191
Unique (%)	42.2%
Missing (%)	53.6%
Missing (n)	243

For privately motivated stays the Senate of Berlin requires 5% City Tax, which must additionally be paid on arrival. Business travelers are exempted from this rule, and are requested to to submit relevant supporting documents upon check-in.	9
Check-in: am Anreisetag ab 14.00 Uhr Check-out: am Abreisetag bis 10.30 Uhr	3
Bereitstellung der Bettwäsche, Handtücher und Küchentücher ist inklusive. Die Preise können je nach Aufenthalts -Länge/ -Zeitpunkt und Anzahl der Personen variieren Garagenplatz 5 €/Nacht. Checkin von (Phone number hidden by Airbnb) h, Checkout bis 11 h Checkin/checkout außerhalb der angegebenen Zeiten nur nach Vereinbarung gegen Gebühr (Phone number hidden by Airbnb) € Gebühr	3
Other values (187)	195
(Missing)	243

Toggle details

Common values
Composition

Value	Count	Frequency (%)
For privately motivated stays the Senate of Berlin requires 5% City Tax, which must additionally be paid on arrival. Business travelers are exempted from this rule, and are requested to to submit relevant supporting documents upon check-in.	9	2.0%
Check-in: am Anreisetag ab 14.00 Uhr Check-out: am Abreisetag bis 10.30 Uhr	3	0.7%
Bereitstellung der Bettwäsche, Handtücher und Küchentücher ist inklusive. Die Preise können je nach Aufenthalts -Länge/ -Zeitpunkt und Anzahl der Personen variieren Garagenplatz 5 €/Nacht. Checkin von (Phone number hidden by Airbnb) h, Checkout bis 11 h Checkin/checkout außerhalb der angegebenen Zeiten nur nach Vereinbarung gegen Gebühr (Phone number hidden by Airbnb) € Gebühr	3	0.7%
The S-Bahn passes behind the apartment. Although the impairments are minor and complaints have not been received yet at all, we would still like mention this.	2	0.4%
Everything is included in the price - no extra payment for anything. Should you be in need of clean clothes. I will assist you with your need for 5€ with drying.	2	0.4%
Guests have to bring their own towels.Bedlinen are being supplied.	2	0.4%
Arrival with car: Our area is on-street parking controlled. From Mondays to Saturdays (9am-midnight) parking costs 1€/hour. On Sundays and red-letter days parking is free of charge. A parking garage nearby is at "Kulturbrauerei" (Mo-Sa; 7,50,-€/day). Guests arriving with a car will need an environmental sticker. Stickers can be issued by the vehicle registration office, technical certification organisations and authorised repair workshops. This applies to foreign vehicles as well. The vehicle registration documents must be presented in order to purchase a sticker.	2	0.4%
Please, consider that you will have to pay a 500 Euro security deposit. If you not travel for business reasons, you will have to pay 5% city tax on arrival.	2	0.4%
Bettwäsche und Handtücher sind im Preis inbegriffen. Es gibt ein Bügeleisen und einen Föhn. Kostenlose Internetverbindung vía Wifi/WLAN. Bitte beachten Sie, dass das Land Berlin seit 2014 für die ersten nicht berufsbedingten (also privaten) 21 Übernachtungen eine Übernachtungsteuer von 5% vom Mietbetrag erhebt, zusätzlich zahlbar bei Anreise. Bei Mietaufenthalten von mehr als 2 Monaten besteht die Verpflichtung sich bei der Meldebehörde anzumelden.	2	0.4%
No place for party people!	2	0.4%
Other values (180)	181	40.0%
(Missing)	243	53.6%

Max length	1000
Mean length	122.5011038
Min length	3
Contains chars	True
Contains digits	True
Contains spaces	True
Contains non-words	True

number_of_reviews
Numeric

Distinct count	178
Unique (%)	39.3%
Missing (%)	0.0%
Missing (n)	0
Infinite (%)	0.0%
Infinite (n)	0

Mean	71.04635762
Minimum	0
Maximum	498
Zeros (%)	3.5%

Toggle details

Quantile statistics

Minimum	0
5-th percentile	1
Q1	11
Median	40
Q3	101
95-th percentile	247.8
Maximum	498
Range	498
Interquartile range	90

Descriptive statistics

Standard deviation	85.41369948
Coef of variation	1.20222489
Kurtosis	4.51946904
Mean	71.04635762
MAD	62.47661652
Skewness	1.998846199
Sum	32184
Variance	7295.500059
Memory size	3.6 KiB

Histogram with fixed size bins (bins=50)

Histogram with variable size bins (bins=[ 0. 1.5 18.5 73.5 164.5 278. 498. ], "bayesian blocks" binning strategy used)

Value	Count	Frequency (%)
0	16	3.5%
1	16	3.5%
6	13	2.9%
3	12	2.6%
5	12	2.6%
18	10	2.2%
7	9	2.0%
4	8	1.8%
10	8	1.8%
15	8	1.8%
Other values (168)	341	75.3%

Minimum 5 values

Value	Count	Frequency (%)
0	16	3.5%
1	16	3.5%
2	6	1.3%
3	12	2.6%
4	8	1.8%

Maximum 5 values

Value	Count	Frequency (%)
498	1	0.2%
443	1	0.2%
426	1	0.2%
413	1	0.2%
398	1	0.2%

picture_url
URL

Distinct count	453
Unique (%)	100.0%
Missing (%)	0.0%
Missing (n)	0

Toggle details

Value	Count	Frequency (%)
https://a0.muscache.com/im/pictures/d9a6f8be-54b9-4b84-bebb-f35970184a4a.jpg?aki_policy=large	1	0.2%
https://a0.muscache.com/im/pictures/67534598/4f349831_original.jpg?aki_policy=large	1	0.2%
https://a0.muscache.com/im/pictures/3228626/693ecd60_original.jpg?aki_policy=large	1	0.2%
https://a0.muscache.com/im/pictures/19704113/d8be97aa_original.jpg?aki_policy=large	1	0.2%
https://a0.muscache.com/im/pictures/95636163/34d5ddca_original.jpg?aki_policy=large	1	0.2%
https://a0.muscache.com/im/pictures/23727213/91c281cb_original.jpg?aki_policy=large	1	0.2%
https://a0.muscache.com/im/pictures/1108358/7c6bbb28_original.jpg?aki_policy=large	1	0.2%
https://a0.muscache.com/im/pictures/2450064/3a8e0ee8_original.jpg?aki_policy=large	1	0.2%
https://a0.muscache.com/im/pictures/90315375/54accf14_original.jpg?aki_policy=large	1	0.2%
https://a0.muscache.com/im/pictures/3e7e95d0-48ca-4bd5-b3d7-9198fe9c67e4.jpg?aki_policy=large	1	0.2%
Other values (443)	443	97.8%

Value	Count	Frequency (%)
https	453	100.0%

Value	Count	Frequency (%)
a0.muscache.com	453	100.0%

Value	Count	Frequency (%)
/im/pictures/33744531/b278510d_original.jpg	1	0.2%
/im/pictures/5785290/e008149e_original.jpg	1	0.2%
/im/pictures/342014/22302c71_original.jpg	1	0.2%
/im/pictures/002e15f4-5fa3-4ba3-be93-009f62b5799b.jpg	1	0.2%
/im/pictures/2563610/bc8110b7_original.jpg	1	0.2%
/im/pictures/4037541/285855e5_original.jpg	1	0.2%
/im/pictures/5753326/d88c0653_original.jpg	1	0.2%
/im/pictures/3395313/68d44d1e_original.jpg	1	0.2%
/im/pictures/103851337/4df5b9c2_original.jpg	1	0.2%
/im/pictures/58427563/6a0e1f94_original.jpg	1	0.2%
Other values (443)	443	97.8%

Value	Count	Frequency (%)
aki_policy=large	453	100.0%

Value	Count	Frequency (%)
	453	100.0%

price
Categorical

Distinct count	104
Unique (%)	23.0%
Missing (%)	0.0%
Missing (n)	0

$55.00	24
$70.00	22
$60.00	20
Other values (101)	387

Toggle details

Common values
Composition

Value	Count	Frequency (%)
$55.00	24	5.3%
$70.00	22	4.9%
$60.00	20	4.4%
$65.00	18	4.0%
$75.00	15	3.3%
$49.00	15	3.3%
$50.00	15	3.3%
$45.00	14	3.1%
$80.00	14	3.1%
$29.00	13	2.9%
Other values (94)	283	62.5%

Max length	7
Mean length	6.112582781
Min length	5
Contains chars	False
Contains digits	True
Contains spaces	False
Contains non-words	True

property_type
Categorical

Distinct count	16
Unique (%)	3.5%
Missing (%)	0.0%
Missing (n)	0

Apartment	378
House	19
Condominium	17
Other values (13)	39

Toggle details

Common values
Composition

Value	Count	Frequency (%)
Apartment	378	83.4%
House	19	4.2%
Condominium	17	3.8%
Loft	11	2.4%
Hostel	9	2.0%
Bed and breakfast	4	0.9%
Other	3	0.7%
Guesthouse	2	0.4%
Townhouse	2	0.4%
Boutique hotel	2	0.4%
Other values (6)	6	1.3%

Max length	18
Mean length	8.792494481
Min length	4
Contains chars	True
Contains digits	False
Contains spaces	True
Contains non-words	True

require_guest_phone_verification
Boolean

Distinct count	2
Unique (%)	0.4%
Missing (%)	0.0%
Missing (n)	0

f	390
t	63

Toggle details

Value	Count	Frequency (%)
f	390	86.1%
t	63	13.9%

require_guest_profile_picture
Boolean

Distinct count	2
Unique (%)	0.4%
Missing (%)	0.0%
Missing (n)	0

f	418
t	35

Toggle details

Value	Count	Frequency (%)
f	418	92.3%
t	35	7.7%

requires_license
Constant

This variable is constant and should be ignored for analysis

Constant value	t

review_scores_accuracy
Numeric

Distinct count	7
Unique (%)	1.5%
Missing (%)	4.2%
Missing (n)	19
Infinite (%)	0.0%
Infinite (n)	0

Mean	9.569124424
Minimum	5
Maximum	10
Zeros (%)	0.0%

Toggle details

Quantile statistics

Minimum	5
5-th percentile	9
Q1	9
Median	10
Q3	10
95-th percentile	10
Maximum	10
Range	5
Interquartile range	1

Descriptive statistics

Standard deviation	0.6803515381
Coef of variation	0.07109861968
Kurtosis	8.859038324
Mean	9.569124424
MAD	0.5519972817
Skewness	-2.30753659
Sum	4153
Variance	0.4628782154
Memory size	3.6 KiB

Histogram with fixed size bins (bins=7)

Value	Count	Frequency (%)
10	278	61.4%
9	135	29.8%
8	16	3.5%
6	3	0.7%
7	1	0.2%
5	1	0.2%
(Missing)	19	4.2%

Minimum 5 values

Value	Count	Frequency (%)
5	1	0.2%
6	3	0.7%
7	1	0.2%
8	16	3.5%
9	135	29.8%

Maximum 5 values

Value	Count	Frequency (%)
10	278	61.4%
9	135	29.8%
8	16	3.5%
7	1	0.2%
6	3	0.7%

review_scores_checkin
Numeric

Distinct count	6
Unique (%)	1.3%
Missing (%)	4.2%
Missing (n)	19
Infinite (%)	0.0%
Infinite (n)	0

Mean	9.665898618
Minimum	4
Maximum	10
Zeros (%)	0.0%

Toggle details

Quantile statistics

Minimum	4
5-th percentile	9
Q1	9
Median	10
Q3	10
95-th percentile	10
Maximum	10
Range	6
Interquartile range	1

Descriptive statistics

Standard deviation	0.6493117684
Coef of variation	0.06717552026
Kurtosis	26.1484077
Mean	9.665898618
MAD	0.478827327
Skewness	-3.812545244
Sum	4195
Variance	0.4216057726
Memory size	3.6 KiB

Histogram with fixed size bins (bins=6)

Value	Count	Frequency (%)
10	311	68.7%
9	110	24.3%
8	10	2.2%
4	2	0.4%
7	1	0.2%
(Missing)	19	4.2%

Minimum 5 values

Value	Count	Frequency (%)
4	2	0.4%
7	1	0.2%
8	10	2.2%
9	110	24.3%
10	311	68.7%

Maximum 5 values

Value	Count	Frequency (%)
10	311	68.7%
9	110	24.3%
8	10	2.2%
7	1	0.2%
4	2	0.4%

review_scores_cleanliness
Numeric

Distinct count	7
Unique (%)	1.5%
Missing (%)	4.2%
Missing (n)	19
Infinite (%)	0.0%
Infinite (n)	0

Mean	9.48156682
Minimum	4
Maximum	10
Zeros (%)	0.0%

Toggle details

Quantile statistics

Minimum	4
5-th percentile	8
Q1	9
Median	10
Q3	10
95-th percentile	10
Maximum	10
Range	6
Interquartile range	1

Descriptive statistics

Standard deviation	0.6936740464
Coef of variation	0.07316027609
Kurtosis	9.751037287
Mean	9.48156682
MAD	0.5829386906
Skewness	-2.060822245
Sum	4115
Variance	0.4811836826
Memory size	3.6 KiB

Histogram with fixed size bins (bins=7)

Value	Count	Frequency (%)
10	244	53.9%
9	163	36.0%
8	23	5.1%
7	2	0.4%
4	1	0.2%
6	1	0.2%
(Missing)	19	4.2%

Minimum 5 values

Value	Count	Frequency (%)
4	1	0.2%
6	1	0.2%
7	2	0.4%
8	23	5.1%
9	163	36.0%

Maximum 5 values

Value	Count	Frequency (%)
10	244	53.9%
9	163	36.0%
8	23	5.1%
7	2	0.4%
6	1	0.2%

review_scores_communication
Numeric

Distinct count	8
Unique (%)	1.8%
Missing (%)	4.2%
Missing (n)	19
Infinite (%)	0.0%
Infinite (n)	0

Mean	9.633640553
Minimum	2
Maximum	10
Zeros (%)	0.0%

Toggle details

Quantile statistics

Minimum	2
5-th percentile	9
Q1	9
Median	10
Q3	10
95-th percentile	10
Maximum	10
Range	8
Interquartile range	1

Descriptive statistics

Standard deviation	0.7331617882
Coef of variation	0.07610433295
Kurtosis	35.46267726
Mean	9.633640553
MAD	0.516617469
Skewness	-4.497039061
Sum	4181
Variance	0.5375262077
Memory size	3.6 KiB

Histogram with fixed size bins (bins=8)

Value	Count	Frequency (%)
10	306	67.5%
9	110	24.3%
8	14	3.1%
4	1	0.2%
2	1	0.2%
7	1	0.2%
6	1	0.2%
(Missing)	19	4.2%

Minimum 5 values

Value	Count	Frequency (%)
2	1	0.2%
4	1	0.2%
6	1	0.2%
7	1	0.2%
8	14	3.1%

Maximum 5 values

Value	Count	Frequency (%)
10	306	67.5%
9	110	24.3%
8	14	3.1%
7	1	0.2%
6	1	0.2%

review_scores_location
Numeric

Distinct count	6
Unique (%)	1.3%
Missing (%)	4.2%
Missing (n)	19
Infinite (%)	0.0%
Infinite (n)	0

Mean	9.513824885
Minimum	6
Maximum	10
Zeros (%)	0.0%

Toggle details

Quantile statistics

Minimum	6
5-th percentile	9
Q1	9
Median	10
Q3	10
95-th percentile	10
Maximum	10
Range	4
Interquartile range	1

Descriptive statistics

Standard deviation	0.6419101307
Coef of variation	0.06747129977
Kurtosis	3.866522418
Mean	9.513824885
MAD	0.5601095797
Skewness	-1.499131842
Sum	4129
Variance	0.4120486159
Memory size	3.6 KiB

Histogram with fixed size bins (bins=6)

Value	Count	Frequency (%)
10	250	55.2%
9	163	36.0%
8	17	3.8%
6	2	0.4%
7	2	0.4%
(Missing)	19	4.2%

Minimum 5 values

Value	Count	Frequency (%)
6	2	0.4%
7	2	0.4%
8	17	3.8%
9	163	36.0%
10	250	55.2%

Maximum 5 values

Value	Count	Frequency (%)
10	250	55.2%
9	163	36.0%
8	17	3.8%
7	2	0.4%
6	2	0.4%

review_scores_rating
Numeric

Distinct count	27
Unique (%)	6.0%
Missing (%)	4.2%
Missing (n)	19
Infinite (%)	0.0%
Infinite (n)	0

Mean	93.62903226
Minimum	73
Maximum	100
Zeros (%)	0.0%

Toggle details

Quantile statistics

Minimum	73
5-th percentile	83
Q1	91
Median	94.5
Q3	97
95-th percentile	100
Maximum	100
Range	27
Interquartile range	6

Descriptive statistics

Standard deviation	5.159191934
Coef of variation	0.05510248061
Kurtosis	1.211616605
Mean	93.62903226
MAD	3.984837223
Skewness	-1.121838086
Sum	40635
Variance	26.61726142
Memory size	3.6 KiB

Histogram with fixed size bins (bins=27)

Value	Count	Frequency (%)
96	49	10.8%
100	48	10.6%
94	41	9.1%
98	39	8.6%
97	37	8.2%
93	36	7.9%
95	26	5.7%
92	25	5.5%
90	19	4.2%
99	18	4.0%
Other values (16)	96	21.2%
(Missing)	19	4.2%

Minimum 5 values

Value	Count	Frequency (%)
73	1	0.2%
75	1	0.2%
76	1	0.2%
77	1	0.2%
79	1	0.2%

Maximum 5 values

Value	Count	Frequency (%)
100	48	10.6%
99	18	4.0%
98	39	8.6%
97	37	8.2%
96	49	10.8%

review_scores_value
Numeric

Distinct count	6
Unique (%)	1.3%
Missing (%)	4.4%
Missing (n)	20
Infinite (%)	0.0%
Infinite (n)	0

Mean	9.270207852
Minimum	6
Maximum	10
Zeros (%)	0.0%

Toggle details

Quantile statistics

Minimum	6
5-th percentile	8
Q1	9
Median	9
Q3	10
95-th percentile	10
Maximum	10
Range	4
Interquartile range	1

Descriptive statistics

Standard deviation	0.6586069778
Coef of variation	0.07104554593
Kurtosis	2.379397733
Mean	9.270207852
MAD	0.5359674434
Skewness	-0.8909035014
Sum	4014
Variance	0.4337631511
Memory size	3.6 KiB

Histogram with fixed size bins (bins=6)

Value	Count	Frequency (%)
9	239	52.8%
10	159	35.1%
8	30	6.6%
7	3	0.7%
6	2	0.4%
(Missing)	20	4.4%

Minimum 5 values

Value	Count	Frequency (%)
6	2	0.4%
7	3	0.7%
8	30	6.6%
9	239	52.8%
10	159	35.1%

Maximum 5 values

Value	Count	Frequency (%)
10	159	35.1%
9	239	52.8%
8	30	6.6%
7	3	0.7%
6	2	0.4%

reviews_per_month
Highly correlated

This variable is highly correlated with number_of_reviews and should be ignored for analysis

Correlation	0.9301967298

room_type
Categorical

Distinct count	3
Unique (%)	0.7%
Missing (%)	0.0%
Missing (n)	0

Entire home/apt	304
Private room	143
Shared room	6

Toggle details

Common values
Composition

Value	Count	Frequency (%)
Entire home/apt	304	67.1%
Private room	143	31.6%
Shared room	6	1.3%

Max length	15
Mean length	14
Min length	11
Contains chars	True
Contains digits	False
Contains spaces	True
Contains non-words	True

scrape_id
Constant

This variable is constant and should be ignored for analysis

Constant value	20181107122246

security_deposit
Categorical

Distinct count	40
Unique (%)	8.8%
Missing (%)	25.2%
Missing (n)	114

$0.00	73
$100.00	48
$200.00	38
Other values (36)	180
(Missing)	114

Toggle details

Common values
Composition

Value	Count	Frequency (%)
$0.00	73	16.1%
$100.00	48	10.6%
$200.00	38	8.4%
$500.00	34	7.5%
$150.00	26	5.7%
$300.00	26	5.7%
$250.00	17	3.8%
$1,000.00	14	3.1%
$400.00	12	2.6%
$800.00	8	1.8%
Other values (29)	43	9.5%
(Missing)	114	25.2%

Max length	9
Mean length	5.770419426
Min length	3
Contains chars	True
Contains digits	True
Contains spaces	False
Contains non-words	True

smart_location
Categorical

Distinct count	3
Unique (%)	0.7%
Missing (%)	0.0%
Missing (n)	0

Berlin, Germany	451
Berlin (Kreuzberg), Germany	1
Schöneberg, Germany	1

Toggle details

Common values
Composition

Value	Count	Frequency (%)
Berlin, Germany	451	99.6%
Berlin (Kreuzberg), Germany	1	0.2%
Schöneberg, Germany	1	0.2%

Max length	27
Mean length	15.03532009
Min length	15
Contains chars	True
Contains digits	False
Contains spaces	True
Contains non-words	True

space
Categorical

Distinct count	435
Unique (%)	96.0%
Missing (%)	1.3%
Missing (n)	6

Our Sunflower Hostel is characterized by its colorful and unconventional design, and offers plenty of space to meet and to exchange with other travelers. For this purpose especially our lobby invites with a bar, table football, plenty of seating and even a small pond with fishes!	9
Welcome to a feel good stay and a quality experience in Berlin. We're offering mature hospitality, good quality in our interior with good beds, you´ll love sleeping in. This is the place to stay, if you want to experience a relaxed however stylish alternative to a hotel we're the place. You're now reading about a semi-professional host's offer to guests visiting Berlin. It means I have more rooms for rent out in the same big and spacey apartment - a 'guest house'. So be course I'm not a newbie in this business is a greater chance for at good stay in Berlin, then if you take a host with no experience and on the hunt for some extra pocket money. I charge a bit more then the other hosts, I don't offer discounts and in return the only thing I'm working for is to provide a good stay and a good nights sleep for my guests. Great apartment, great room, big kitchen and two baths/toilets! The room is big and spacious and decorated to give you a space to relax. The apartment is in a very quiet	3
Lovely Apartment for two persons. Nice and sunny reasonable Apartment, 35 qm, modernized, quietly, traffic favourable.	2
Other values (431)	433
(Missing)	6

Toggle details

Common values
Composition

Value	Count	Frequency (%)
Our Sunflower Hostel is characterized by its colorful and unconventional design, and offers plenty of space to meet and to exchange with other travelers. For this purpose especially our lobby invites with a bar, table football, plenty of seating and even a small pond with fishes!	9	2.0%
Welcome to a feel good stay and a quality experience in Berlin. We're offering mature hospitality, good quality in our interior with good beds, you´ll love sleeping in. This is the place to stay, if you want to experience a relaxed however stylish alternative to a hotel we're the place. You're now reading about a semi-professional host's offer to guests visiting Berlin. It means I have more rooms for rent out in the same big and spacey apartment - a 'guest house'. So be course I'm not a newbie in this business is a greater chance for at good stay in Berlin, then if you take a host with no experience and on the hunt for some extra pocket money. I charge a bit more then the other hosts, I don't offer discounts and in return the only thing I'm working for is to provide a good stay and a good nights sleep for my guests. Great apartment, great room, big kitchen and two baths/toilets! The room is big and spacious and decorated to give you a space to relax. The apartment is in a very quiet	3	0.7%
Lovely Apartment for two persons. Nice and sunny reasonable Apartment, 35 qm, modernized, quietly, traffic favourable.	2	0.4%
Dear holiday-guests, the multi-family flat has an historic background of formerly being a barn-house for carriage drivers in 1906. It is located in the gorgeous and very safe siting of Berlin Wannsee. The area of Wannsee, in which the two apartments lie, offers a beautiful variety of landscape, spreading from forest, to lakes and to culture. This however does not limit the quick access into the city, be it by car or by public transportation. The S-Bahn station Wannsee can easily be approached by foot. From there the S-Bahn will transport you every 10 minutes to areas like the Ku’damm (20 minutes) or the Potsdamer Platz (30 minutes). Potsdam is practically around the corner. The apartments (one in ground floor and one in first floor) each feature a little separate bedroom and a combined living-room and dining-room with an additional sofa-bed. They can be booked for up to two adults and two children. These living facilities are very well equipped and furnished with a love for detail (Wi-	2	0.4%
The accommodation is located in the district of Neukölln, in the middle of the old Bohemian Rixdorf, a historical working class quarter that was once founded in 1737. Berlin-Neukölln offers many cafés, bars and shopping opportunities, international cultural offerings such as the Neukölln opera, movies, numerous galleries as well as the Volkspark Hasenheide are within walking distance. We offer single, double, 3 beds rooms and a holiday home. There are 2 shared bathrooms and a small kitchen available for the rooms. They are also suitable for small groups of up to 10 persons. The holiday apartment is suitable for up to 4 persons and is situated on the 2nd floor. It has 1 room with TV, bathroom, kitchen and a washing machine. Berlin offers many opportunities to experience both historical & modern culture and space to relax. The growing together of East and West can be intensely experienced in Berlin, in particular. Among the most attracting sights you find the historical city center with	2	0.4%
very sunny room near metro Breitenbachplatz in Berlin Steglitz with Internet and phone	1	0.2%
If you are looking for a central place to stay and to explore the city, with a feel-home atmosphere (not hotel-like) and personal contact to a Berlin family, then you are right here! Our spacious guest room (25 m2) will take you on a little trip to Asia, giving you the possibility to relax after an exciting day in Berlin. The room has a double bed (new!) and a spare guest mattress as well as an own access to the balcony. Kitchen, small bathroom, living room and balcony are shared. Therefore, we prefer women as guests. Thanks for your understanding. Sheets and towels are included. Just a few minutes to walk you can spend your day around the Kollwitzplatz / Kastanienallee area. There are lots of nice cafes, restaurants and bars. On Saturdays, you could check out the Kollwitz Market for food, flowers and craftwork from Berlin. On Sundays, you might want to walk to the flea markets at Mauerpark or Arkonaplatz. Main tourist attractions such as Brandenburger Gate, Reichstag and the museum	1	0.2%
Komfortabel eingerichtetes Einzimmerappartement, ausgestattet für bis zu 3 Personen mit Doppelbett, einer Schlafcouch (80&195cm), Esstisch, Schrank und SAT-TV. Es ist eine kleine, helle Wohnung in der Kalckreuthstr. 7 im 3.OG mit Aufzug. Das Bad des Appartements ist gefliest und mit einer Dusche und einer Waschmaschine versehen. Es fließt wahlweise Kalt-/ Warm- oder Heißwasser. Die kleine Küche mit einem Kühlschrank, Kaffeemaschine, Wasserkocher, Toaster und einem Elektroherd (4 Herdplatten) mit Backofen lädt zur Selbstverpflegung ein. Internetverbindung vía WLAN/Wifi.	1	0.2%
My bright 2 rooms appartment is in the 2. floor and has an elevator. The sleeping room has a kingsize bed. The bathroom has a bathtab (shower) and washingmachine. In the kitchen you find everything for cooking or preparing your breakfast. In the living room you have a big and comfortable sleeping couch for 2 persons and a big nice table. There is a nice balcony directly over a quiet street. It´s a non smoker appartment, but of course you can smoke on the balcony. I´m musician and travel a lot. Peter gives you the keys and helps you with everything around the appartment. He is also cleaning after you leave. After booking my flat I will send you Peter´s email-adress and phonenumber so that you can arrange check-in and check-out directly with him.	1	0.2%
I want to rent out my fully furnished apartment (538 sq ft, 50 qm) in Berlin-Pankow near Prenzlauer Berg. It is located in the very safe residential area. Nearby you have different supermarkets (Netto, ALDI, Kaisers), a bakery, two restaurants, a late shop and a petrol station. My apartment is in the first floor, very cozy, well organized, comfortable and on 50 qm you have enough space for up to 5-6 persons. It has two separate rooms - a spacious room with a double bed and a single bed) and a room with a single bed and a fould-out sofa bed for 2, a fully equipped kitchen, a bathroom with bathtub and a balcony. In room 1 are a fould-out sofa bed (for (PHONE NUMBER HIDDEN)) and a single bed (120 x 200) perfect for two or three people. There are a double bed (160 x 200) and a single bed (90 x 200) in room 2, so it's perfect for 3 more people. There is everything needed for daily life (free WIRELESS CONNECTION, bed linen, blankets, two desks, two wardrobes, high boards, seatings, househ	1	0.2%
Other values (424)	424	93.6%
(Missing)	6	1.3%

Max length	1000
Mean length	819.0684327
Min length	3
Contains chars	True
Contains digits	True
Contains spaces	True
Contains non-words	True

square_feet
Numeric

Distinct count	68
Unique (%)	15.0%
Missing (%)	63.1%
Missing (n)	286
Infinite (%)	0.0%
Infinite (n)	0

Mean	416.6407186
Minimum	0
Maximum	1722
Zeros (%)	9.9%

Toggle details

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
Median	377
Q3	662
95-th percentile	1275.8
Maximum	1722
Range	1722
Interquartile range	662

Descriptive statistics

Standard deviation	402.6682724
Coef of variation	0.9664640408
Kurtosis	0.90989614
Mean	416.6407186
MAD	322.1080713
Skewness	1.00931902
Sum	69579
Variance	162141.7376
Memory size	3.6 KiB

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	45	9.9%
753	7	1.5%
646	7	1.5%
269	5	1.1%
807	4	0.9%
775	4	0.9%
377	4	0.9%
431	4	0.9%
474	3	0.7%
484	3	0.7%
Other values (57)	81	17.9%
(Missing)	286	63.1%

Minimum 5 values

Value	Count	Frequency (%)
0	45	9.9%
15	1	0.2%
17	1	0.2%
20	1	0.2%
46	1	0.2%

Maximum 5 values

Value	Count	Frequency (%)
1722	2	0.4%
1615	2	0.4%
1400	1	0.2%
1399	1	0.2%
1292	3	0.7%

state
Categorical

Distinct count	2
Unique (%)	0.4%
Missing (%)	0.7%
Missing (n)	3

Berlin	450
(Missing)	3

Toggle details

Common values
Composition

Value	Count	Frequency (%)
Berlin	450	99.3%
(Missing)	3	0.7%

Max length	6
Mean length	5.98013245
Min length	3
Contains chars	True
Contains digits	False
Contains spaces	False
Contains non-words	False

street
Categorical

Distinct count	4
Unique (%)	0.9%
Missing (%)	0.0%
Missing (n)	0

Berlin, Berlin, Germany	448
Berlin, Germany	3
Berlin (Kreuzberg), Berlin, Germany	1

Toggle details

Common values
Composition

Value	Count	Frequency (%)
Berlin, Berlin, Germany	448	98.9%
Berlin, Germany	3	0.7%
Berlin (Kreuzberg), Berlin, Germany	1	0.2%
Schöneberg, Berlin, Germany	1	0.2%

Max length	35
Mean length	22.98233996
Min length	15
Contains chars	True
Contains digits	False
Contains spaces	True
Contains non-words	True

summary
Categorical

Distinct count	285
Unique (%)	62.9%
Missing (%)	34.4%
Missing (n)	156

Die Unterkünfte liegen im Bezirk Neukölln mitten im 1737 gegründeten historischen Arbeiterviertel Böhmisch-Rixdorf. In unmittelbarer Umgebung: Cafés, Bars, Einkaufsmöglichkeiten, Neuköllner Oper, Kinos, zahlreiche Galerien, Volkspark Hasenheide und Tempelhofer Feld. Auf Wunsch Stadtführungen mit sachkundigen Stadtführern. Hierzu beraten wir Sie gern. Für Gruppen bis 8 Personen bieten wir Führungen für 20 Euro an, jede weitere Person 2 Euro. Die Nutzung des Berliner Nahverkehrs kostet extra.	5
we are a guesthouse and not a private appartment. every room/appartment with its own entrance and bathroom.	4
Schön eingerichtete 3-Zimmerwohnung mit 2 Schlafzimmern und Internetanschluss . Aus der 10. Etg eines Mehrfamilienhauses gibt es einen herrlichen Ausblick auf den Fernsehturm und den Alexanderplatz in der Nähe.	4
Other values (281)	284
(Missing)	156

Toggle details

Common values
Composition

Value	Count	Frequency (%)
Die Unterkünfte liegen im Bezirk Neukölln mitten im 1737 gegründeten historischen Arbeiterviertel Böhmisch-Rixdorf. In unmittelbarer Umgebung: Cafés, Bars, Einkaufsmöglichkeiten, Neuköllner Oper, Kinos, zahlreiche Galerien, Volkspark Hasenheide und Tempelhofer Feld. Auf Wunsch Stadtführungen mit sachkundigen Stadtführern. Hierzu beraten wir Sie gern. Für Gruppen bis 8 Personen bieten wir Führungen für 20 Euro an, jede weitere Person 2 Euro. Die Nutzung des Berliner Nahverkehrs kostet extra.	5	1.1%
we are a guesthouse and not a private appartment. every room/appartment with its own entrance and bathroom.	4	0.9%
Schön eingerichtete 3-Zimmerwohnung mit 2 Schlafzimmern und Internetanschluss . Aus der 10. Etg eines Mehrfamilienhauses gibt es einen herrlichen Ausblick auf den Fernsehturm und den Alexanderplatz in der Nähe.	4	0.9%
Exceptional guestroom in the back of the legendary Berlin Kinomuseum. We offer one single and one double room, regulary Salon Evenings and Film Screenings. Truly unique in Berlin!	2	0.4%
Im sanierten Seitenflügel eines Altbau-Wohnhauses im Friedrichshainer Kiez, mit kurzen Wegen zur S-Bahn, DB-Bahn, Flughafen, zum Alexanderplatz, Park oder zur Spree	2	0.4%
Large room that can accommodate up to 6 people. It has 3 bunk beds and is very suitable for small groups. The spacious bathroom is for multiple rooms.	2	0.4%
Light and sunny 1-Room-turn of the century-flat in a typical Berliner front house in the best part of Kreuzberg.	1	0.2%
The rare and much sought after Altbaus of Berlin are a joy to experience! These are the grand apartments from before first world war with high ceilings and Flur that leads to each and every room. Come-in and enjoy this unique experience! All-inclusive pricing, completely flexible cancellation and no check-in/out restrictions... we travel a lot and hence, we know what we expect when we are the guests! :)	1	0.2%
The apartment, located in the centre of Berlin, is bright and comfortable, equipped with everything you need. What I particulary like is the nice urban view from the 9th floor. See you soon.	1	0.2%
The apartment is located in the heart of West Berlin, surrounded by pre-WWII residential buildings, a variety of high end designers stores, cafe's and restaurants. The famous Kaiser Wilhelm Memorial Church, which is across the Waldorf Astoria, is only 15 min walking distance away.	1	0.2%
Other values (274)	274	60.5%
(Missing)	156	34.4%

Max length	500
Mean length	163.7792494
Min length	3
Contains chars	True
Contains digits	True
Contains spaces	True
Contains non-words	True

thumbnail_url
Constant

This variable is constant and should be ignored for analysis

Constant value	nan

transit
Categorical

Distinct count	265
Unique (%)	58.5%
Missing (%)	36.2%
Missing (n)	164

The connection to the public transport network (metro, urban railway, bus, tram) and the central location between Prenzlauer Berg and the Spree guarantee an ideal place to find us easily and to explore Berlin and its surroundings afterwords. Urban railway / S-Bahn: Warschauer Straße (S3, S5, S7, S75): 5 min Metro / U-Bahn: Warschauer Straße (U1): 6 min Frankfurter Tor (U5): 12 min Tram: Warschauer- / Revaler Straße (M10, M13): 4 min Bus: Helsingforser Platz (347, N1): 3 min (all times are by walking)	8
Zwei U-Bahnhöfe in der Nähe, dabei direkte Verbindung zum Alexanderplatz. Kostenlose Parkmöglichkeiten in unmittelbarer Umgebung.	5
Der Bahnhof Ostkreuz ist nur 7 Gehminuten entfernt, der eine schlelle Verbindung zu den Flughäfen, Bahnhof und ins ganze Stadtgebiet ermöglicht.	3
Other values (261)	273
(Missing)	164

Toggle details

Common values
Composition

Value	Count	Frequency (%)
The connection to the public transport network (metro, urban railway, bus, tram) and the central location between Prenzlauer Berg and the Spree guarantee an ideal place to find us easily and to explore Berlin and its surroundings afterwords. Urban railway / S-Bahn: Warschauer Straße (S3, S5, S7, S75): 5 min Metro / U-Bahn: Warschauer Straße (U1): 6 min Frankfurter Tor (U5): 12 min Tram: Warschauer- / Revaler Straße (M10, M13): 4 min Bus: Helsingforser Platz (347, N1): 3 min (all times are by walking)	8	1.8%
Zwei U-Bahnhöfe in der Nähe, dabei direkte Verbindung zum Alexanderplatz. Kostenlose Parkmöglichkeiten in unmittelbarer Umgebung.	5	1.1%
Der Bahnhof Ostkreuz ist nur 7 Gehminuten entfernt, der eine schlelle Verbindung zu den Flughäfen, Bahnhof und ins ganze Stadtgebiet ermöglicht.	3	0.7%
Der S-Bahnhof "Beusselstr" ist zu Fuß 5 Minuten entfernt, mit der dort fahrenden Ringbahn kommt man schnell überall hin. Ebenfalls am S-Bahnhof fahren mehrere Buslinien, u. a. zum Hauptbahnhof, zum Flughafen Tegel, zum Alexanderplatz... Die nächste U-Bahnstation "Birkenstrasse" ist zu Fuß ca. 15 Minuten entfernt, man kann aber auch mit der S-Bahn fahren und umsteigen.	3	0.7%
Access to S-Bahn and Regionalbahn takes around 13 minutes of walking.	2	0.4%
The train and tram station "Greifswalder Straße" is only 200m away and will take you directly to: * the Alexander Platz - 10 minutes. * the Museum Island with the famous Berliner Dom, Hackescher Markt - 15 minutes * Schönefeld Airport (SFX) - 35 minutes Or with one change of trains to * Tegel Airport (TXL) - 25 minutes * the Brandenburg Gate - 20 minutes * Checkpoint Charlie - 25 minutes The M10 tram station is 700m away and will take you directly to the East Side Gallery (15 minutes)	2	0.4%
Close to all public transport connections (a few minutes walk) Underground line U6 Overground train - Friedrichstrasse , Nordbahnhof & Hauptbahnhof Tram connections - Friedrichstrasse & Nordbahnhof	2	0.4%
1000 m to Hauptbahnhof City train Nordbahnhof 3 min Subway station Oranienburger Tor 5 min	2	0.4%
Die M 68 Straßenbahn ( eine 100 Jahre alte Linie ) fährt Sie am Strandbad Grünau bis zur S - Bahn. Von dort haben Sie 2 Verbindungen zur City	2	0.4%
U8 Schönleinstraße	2	0.4%
Other values (254)	258	57.0%
(Missing)	164	36.2%

Max length	1000
Mean length	182.8432671
Min length	3
Contains chars	True
Contains digits	True
Contains spaces	True
Contains non-words	True

weekly_price
Categorical

Distinct count	106
Unique (%)	23.4%
Missing (%)	40.6%
Missing (n)	184

$300.00	16
$350.00	13
$200.00	12
Other values (102)	228
(Missing)	184

Toggle details

Common values
Composition

Value	Count	Frequency (%)
$300.00	16	3.5%
$350.00	13	2.9%
$200.00	12	2.6%
$420.00	10	2.2%
$500.00	10	2.2%
$450.00	8	1.8%
$250.00	7	1.5%
$600.00	6	1.3%
$260.00	6	1.3%
$340.00	6	1.3%
Other values (95)	175	38.6%
(Missing)	184	40.6%

Max length	9
Mean length	5.397350993
Min length	3
Contains chars	True
Contains digits	True
Contains spaces	False
Contains non-words	True

xl_picture_url
Constant

This variable is constant and should be ignored for analysis

Constant value	nan

zipcode
Categorical

Distinct count	107
Unique (%)	23.6%
Missing (%)	0.7%
Missing (n)	3

10437	28
10119	25
10405	23
Other values (103)	374

Toggle details

Common values
Composition

Value	Count	Frequency (%)
10437	28	6.2%
10119	25	5.5%
10405	23	5.1%
10435	21	4.6%
10115	21	4.6%
10997	19	4.2%
10245	18	4.0%
10243	14	3.1%
10117	12	2.6%
10247	12	2.6%
Other values (96)	257	56.7%

Max length	11
Mean length	5
Min length	3
Contains chars	True
Contains digits	True
Contains spaces	True
Contains non-words	True

First rows

	access	accommodates	amenities	availability_30	availability_365	availability_60	availability_90	bathrooms	bed_type	bedrooms	beds	calculated_host_listings_count	calendar_last_scraped	calendar_updated	cancellation_policy	city	cleaning_fee	country	country_code	description	experiences_offered	extra_people	first_review	guests_included	has_availability	host_about	host_acceptance_rate	host_has_profile_pic	host_id	host_identity_verified	host_is_superhost	host_listings_count	host_location	host_name	host_neighbourhood	host_picture_url	host_response_rate	host_response_time	host_since	host_thumbnail_url	host_total_listings_count	host_url	host_verifications	house_rules	id	instant_bookable	interaction	is_business_travel_ready	is_location_exact	jurisdiction_names	last_review	last_scraped	latitude	license	listing_url	longitude	market	maximum_nights	medium_url	minimum_nights	monthly_price	name	neighborhood_overview	neighbourhood	neighbourhood_cleansed	neighbourhood_group_cleansed	notes	number_of_reviews	picture_url	price	property_type	require_guest_phone_verification	require_guest_profile_picture	requires_license	review_scores_accuracy	review_scores_checkin	review_scores_cleanliness	review_scores_communication	review_scores_location	review_scores_rating	review_scores_value	reviews_per_month	room_type	scrape_id	security_deposit	smart_location	space	square_feet	state	street	summary	thumbnail_url	transit	weekly_price	xl_picture_url	zipcode
0	Simple kitchen/cooking, refrigerator, microwav...	3	{TV,"Cable TV",Wifi,Kitchen,Gym,Heating,"Famil...	0	141	21	51	1.0	Real Bed	1.0	2.0	4	2018-11-07	3 months ago	strict_14_with_grace_period	Berlin	$30.00	Germany	DE	Great location! 30 of 75 sq meters. This wood...	none	$28.00	2016-04-11	1	t	Believe in sharing economy.	NaN	t	2217	t	t	4	Key Biscayne, Florida, United States	Ian	Mitte	https://a0.muscache.com/im/pictures/21428a22-4...	96%	within an hour	2008-08-18	https://a0.muscache.com/im/pictures/21428a22-4...	4	https://www.airbnb.com/users/show/2217	['email', 'phone', 'reviews', 'jumio', 'offlin...	No parties No events No pets No smoking, not e...	2015	f	Always available	f	f	NaN	2018-10-28	2018-11-07	52.534537	NaN	https://www.airbnb.com/rooms/2015	13.402557	Berlin	1125	NaN	4	NaN	Berlin-Mitte Value! Quiet courtyard/very central	It is located in the former East Berlin area o...	Mitte	Brunnenstr. Süd	Mitte	This is my home, not a hotel. I rent out occas...	118	https://a0.muscache.com/im/pictures/260fd609-7...	$60.00	Guesthouse	f	f	t	10.0	10.0	9.0	10.0	10.0	93.0	9.0	3.76	Entire home/apt	20181107122246	$200.00	Berlin, Germany	A+++ location! This „Einliegerwohnung“ is an e...	NaN	Berlin	Berlin, Berlin, Germany	Great location! 30 of 75 sq meters. This wood...	NaN	Close to U-Bahn U8 and U2 (metro), Trams M12, ...	NaN	NaN	10119
1	Außer deinem Zimmer kannst du noch die Küche u...	2	{Wifi,Kitchen,Elevator,Heating,Washer,Essentia...	0	0	0	0	1.0	Real Bed	1.0	1.0	1	2018-11-07	7 weeks ago	flexible	Berlin	$0.00	Germany	DE	In the summertime we are spending most of our ...	none	$0.00	2018-07-04	1	t	Living with my wife in Berlin. Like travellin...	NaN	t	2986	t	f	1	Berlin, Berlin, Germany	Michael	Prenzlauer Berg	https://a0.muscache.com/im/pictures/50434955-1...	NaN	NaN	2008-09-16	https://a0.muscache.com/im/pictures/50434955-1...	1	https://www.airbnb.com/users/show/2986	['email', 'phone', 'reviews', 'jumio', 'govern...	NaN	2695	f	NaN	f	t	NaN	2018-10-01	2018-11-07	52.548513	NaN	https://www.airbnb.com/rooms/2695	13.404553	Berlin	40	NaN	2	NaN	Prenzlauer Berg close to Mauerpark	NaN	NaN	Prenzlauer Berg Nordwest	Pankow	NaN	6	https://a0.muscache.com/im/pictures/97d4f6e8-1...	$17.00	Apartment	f	f	t	10.0	10.0	10.0	10.0	10.0	100.0	10.0	1.42	Private room	20181107122246	$0.00	Berlin, Germany	In the summertime we are spending most of our ...	NaN	Berlin	Berlin, Berlin, Germany	NaN	NaN	Within walking distance you'll find the S-Bahn...	NaN	NaN	10437
2	The apartment will be entirely yours. We are c...	4	{Internet,Wifi,Kitchen,"Buzzer/wireless interc...	0	220	0	0	1.0	Real Bed	1.0	2.0	1	2018-11-07	a week ago	strict_14_with_grace_period	Berlin	$50.00	Germany	DE	This beautiful first floor apartment is situa...	none	$20.00	2009-06-20	2	t	We love to travel ourselves a lot and prefer t...	NaN	t	3718	t	f	1	Coledale, New South Wales, Australia	Britta	Prenzlauer Berg	https://a0.muscache.com/im/users/3718/profile_...	100%	within a day	2008-10-19	https://a0.muscache.com/im/users/3718/profile_...	1	https://www.airbnb.com/users/show/3718	['email', 'phone', 'facebook', 'reviews', 'man...	It’s a non smoking flat, which likes to be tre...	3176	t	Feel free to ask any questions prior to bookin...	f	t	NaN	2017-03-20	2018-11-07	52.534996	NaN	https://www.airbnb.com/rooms/3176	13.417579	Berlin	1125	NaN	62	$1,900.00	Fabulous Flat in great Location	The neighbourhood is famous for its variety of...	Prenzlauer Berg	Prenzlauer Berg Südwest	Pankow	We welcome FAMILIES and cater especially for y...	143	https://a0.muscache.com/im/pictures/243355/84a...	$90.00	Apartment	f	f	t	9.0	9.0	9.0	9.0	10.0	92.0	9.0	1.25	Entire home/apt	20181107122246	$200.00	Berlin, Germany	1st floor (68m2) apartment on Kollwitzplatz/ P...	720.0	Berlin	Berlin, Berlin, Germany	This beautiful first floor apartment is situa...	NaN	We are 5 min walk away from the tram M2, whic...	$520.00	NaN	10405
3	I do have a strictly non-smoker-flat. Keep th...	2	{Internet,Wifi,"Pets allowed","Pets live on th...	0	297	0	22	1.0	Pull-out Sofa	1.0	1.0	1	2018-11-07	4 weeks ago	strict_14_with_grace_period	Berlin	$30.00	Germany	DE	First of all: I prefer short-notice bookings. ...	none	$18.00	2013-08-12	1	t	ENJOY EVERY DAY AS IF IT'S YOUR LAST!!! \r\n\r...	NaN	t	4108	t	f	1	Berlin, Berlin, Germany	Jana	Schöneberg	https://a0.muscache.com/im/pictures/user/b5938...	NaN	NaN	2008-11-07	https://a0.muscache.com/im/pictures/user/b5938...	1	https://www.airbnb.com/users/show/4108	['email', 'phone', 'reviews', 'jumio', 'govern...	House-Rules and Information ..............(deu...	3309	f	I'm working as a freelancing photographer. My ...	f	t	NaN	2018-08-16	2018-11-07	52.498855	NaN	https://www.airbnb.com/rooms/3309	13.349065	Berlin	360	NaN	5	$599.00	BerlinSpot Schöneberg near KaDeWe	My flat is in the middle of West-Berlin, direc...	Schöneberg	Schöneberg-Nord	Tempelhof - Schöneberg	The flat is a strictly non-smoking facility! A...	25	https://a0.muscache.com/im/pictures/29054294/b...	$26.00	Apartment	f	f	t	9.0	9.0	9.0	10.0	9.0	88.0	9.0	0.39	Private room	20181107122246	$250.00	Berlin, Germany	Your room is really big and has 26 sqm, is ver...	0.0	Berlin	Berlin, Berlin, Germany	First of all: I prefer short-notice bookings. ...	NaN	The public transportation is excellent: Severa...	$175.00	NaN	10777
4	The guests have access to the bathroom, a smal...	2	{Wifi,Heating,"Family/kid friendly",Essentials...	15	26	26	26	1.0	Real Bed	1.0	2.0	1	2018-11-07	3 days ago	moderate	Berlin	$0.00	Germany	DE	Cozy and large room in the beautiful district ...	none	$24.00	2009-08-18	1	t	I'm a creative person, adventurer, and travele...	NaN	t	17391	t	t	1	Berlin, Berlin, Germany	Bright	Prenzlauer Berg	https://a0.muscache.com/im/pictures/user/48c3d...	100%	within an hour	2009-05-16	https://a0.muscache.com/im/pictures/user/48c3d...	1	https://www.airbnb.com/users/show/17391	['email', 'phone', 'reviews', 'jumio', 'govern...	Please take good care of everything during you...	7071	f	I am glad if I can give you advice or help as ...	f	t	NaN	2018-11-04	2018-11-07	52.543157	NaN	https://www.airbnb.com/rooms/7071	13.415091	Berlin	10	NaN	2	NaN	BrightRoom with sunny greenview!	Great neighborhood with plenty of Cafés, Baker...	Prenzlauer Berg	Helmholtzplatz	Pankow	I hope you enjoy your stay to the fullest! Ple...	197	https://a0.muscache.com/im/pictures/21278/32a1...	$42.00	Apartment	f	f	t	10.0	10.0	10.0	10.0	10.0	96.0	9.0	1.75	Private room	20181107122246	$0.00	Berlin, Germany	The BrightRoom is an approx. 20 sqm (215ft²), ...	NaN	Berlin	Berlin, Berlin, Germany	Cozy and large room in the beautiful district ...	NaN	Best access to other parts of the city via pub...	NaN	NaN	10437
5	All amenities shared - nothing off limits	7	{TV,"Cable TV",Internet,Wifi,Kitchen,"Paid par...	0	137	7	7	2.5	Real Bed	4.0	7.0	1	2018-11-07	2 weeks ago	strict_14_with_grace_period	Berlin	$80.00	Germany	DE	4 bedroom with very large windows and outstand...	none	$10.00	2015-08-09	5	t	Born in Munich - lives in and loves Berlin. Wo...	NaN	t	33852	t	f	1	Berlin, Berlin, Germany	Philipp	Prenzlauer Berg	https://a0.muscache.com/im/users/33852/profile...	100%	within a few hours	2009-08-25	https://a0.muscache.com/im/users/33852/profile...	1	https://www.airbnb.com/users/show/33852	['email', 'phone', 'facebook', 'reviews', 'jum...	NaN	9991	f	Guests will have the whole apartment to themse...	f	f	NaN	2018-07-23	2018-11-07	52.533031	03/Z/RA/003410-18	https://www.airbnb.com/rooms/9991	13.416047	Berlin	14	NaN	6	NaN	Geourgeous flat - outstanding views	Prenzlauer Berg is an amazing neighbourhood wh...	Prenzlauer Berg	Prenzlauer Berg Südwest	Pankow	NaN	6	https://a0.muscache.com/im/pictures/42799131/5...	$180.00	Apartment	f	f	t	10.0	10.0	10.0	10.0	10.0	100.0	10.0	0.15	Entire home/apt	20181107122246	$400.00	Berlin, Germany	THE APPARTMENT - 4 bedroom (US, Germany: 5 roo...	NaN	Berlin	Berlin, Berlin, Germany	4 bedroom with very large windows and outstand...	NaN	Excellent location regarding public transport ...	$650.00	NaN	10405
6	NaN	2	{TV,Internet,Wifi,Kitchen,"Buzzer/wireless int...	0	129	0	0	1.0	Real Bed	0.0	1.0	3	2018-11-07	today	strict_14_with_grace_period	Berlin	$0.00	Germany	DE	The apartment is located on the upper second f...	none	$0.00	2010-06-29	1	t	From Berlin, Germany. Working at ‘Welcome Beyo...	NaN	t	55531	f	f	3	Berlin, Berlin, Germany	Chris + Oliver	Prenzlauer Berg	https://a0.muscache.com/im/users/55531/profile...	100%	within a day	2009-11-18	https://a0.muscache.com/im/users/55531/profile...	3	https://www.airbnb.com/users/show/55531	['email', 'phone', 'reviews', 'jumio', 'offlin...	No smoking, loud music or hosting parties at t...	14325	f	NaN	f	t	NaN	2018-11-01	2018-11-07	52.547846	NaN	https://www.airbnb.com/rooms/14325	13.405562	Berlin	1125	NaN	90	$820.00	Apartment in Prenzlauer Berg	NaN	Prenzlauer Berg	Prenzlauer Berg Nordwest	Pankow	NaN	23	https://a0.muscache.com/im/pictures/508703/249...	$70.00	Apartment	f	f	t	10.0	9.0	10.0	10.0	9.0	93.0	9.0	0.23	Entire home/apt	20181107122246	$500.00	Berlin, Germany	The apartment is located on the south-facing s...	NaN	Berlin	Berlin, Berlin, Germany	The apartment is located on the upper second f...	NaN	NaN	$420.00	NaN	10437
7	NaN	2	{TV,"Cable TV",Internet,Wifi,Kitchen,"Smoking ...	30	365	60	90	1.0	Real Bed	1.0	2.0	1	2018-11-07	never	strict_14_with_grace_period	Berlin	NaN	Germany	DE	Hello future guests! We want to rent our cute ...	none	$13.00	NaN	1	t	I'm uncomplicated, funny, curious and I love t...	NaN	t	59666	t	f	1	Berlin, Berlin, Germany	Melanie	Friedrichshain	https://a0.muscache.com/im/pictures/65266732-d...	NaN	NaN	2009-12-03	https://a0.muscache.com/im/pictures/65266732-d...	1	https://www.airbnb.com/users/show/59666	['email', 'phone', 'facebook', 'jumio', 'offli...	NaN	16401	f	NaN	f	t	NaN	NaN	2018-11-07	52.510514	NaN	https://www.airbnb.com/rooms/16401	13.457850	Berlin	52	NaN	30	NaN	APARTMENT TO RENT	NaN	Friedrichshain	Frankfurter Allee Süd FK	Friedrichshain-Kreuzberg	NaN	0	https://a0.muscache.com/im/pictures/4753854/99...	$120.00	Apartment	f	f	t	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	Private room	20181107122246	NaN	Berlin, Germany	Hello future guests! We want to rent our cute ...	NaN	Berlin	Berlin, Berlin, Germany	NaN	NaN	NaN	NaN	NaN	10245
8	The guests use the whole apartment alone. Part...	5	{TV,Wifi,Kitchen,"Buzzer/wireless intercom",He...	0	159	0	0	1.0	Real Bed	1.0	3.0	2	2018-11-07	2 months ago	strict_14_with_grace_period	Berlin	$50.00	Germany	DE	Light and sunny 2-Room-turn of the century-fla...	none	$20.00	2010-06-04	2	t	Friendly and social. Likes to travel and enjoy...	NaN	t	64696	f	f	4	Santa Cruz, California, United States	Rene	Kreuzberg	https://a0.muscache.com/im/users/64696/profile...	100%	within a few hours	2009-12-20	https://a0.muscache.com/im/users/64696/profile...	4	https://www.airbnb.com/users/show/64696	['email', 'phone', 'facebook', 'reviews', 'kba']	1. No noise after 10 pm PLEASE. 2. Please do n...	16644	f	The guest determines how much interaction they...	f	t	NaN	2017-12-14	2018-11-07	52.504792	NaN	https://www.airbnb.com/rooms/16644	13.435102	Berlin	365	NaN	60	$1,440.00	In the Heart of Berlin - Kreuzberg	Our Part of Kreuzberg is just the best. Good v...	Kreuzberg	nördliche Luisenstadt	Friedrichshain-Kreuzberg	NaN	48	https://a0.muscache.com/im/pictures/73759174/e...	$90.00	Apartment	t	f	t	10.0	10.0	10.0	10.0	9.0	94.0	9.0	0.47	Entire home/apt	20181107122246	$500.00	Berlin, Germany	Rent in the heart of Berlin - Kreuzberg Newly ...	0.0	Berlin	Berlin, Berlin, Germany	Light and sunny 2-Room-turn of the century-fla...	NaN	Ostbahnhof is close so you can get here by tra...	$520.00	NaN	10997
9	The roof terrace and the kitchen can be used b...	2	{TV,Internet,Wifi,Kitchen,"Paid parking off pr...	8	42	18	42	1.0	Real Bed	1.0	1.0	1	2018-11-07	a week ago	strict_14_with_grace_period	Berlin	$18.00	Germany	DE	The 25 sqm room is located in the heart of Ber...	none	$26.00	2010-10-07	1	t	A Political journalist and well acquainted wit...	NaN	t	67590	t	t	1	Berlin, Berlin, Germany	Wolfram	Prenzlauer Berg	https://a0.muscache.com/im/pictures/user/a3d84...	100%	within an hour	2010-01-04	https://a0.muscache.com/im/pictures/user/a3d84...	1	https://www.airbnb.com/users/show/67590	['email', 'phone', 'facebook', 'reviews', 'kba']	No smoking in the room, but possible outside o...	17409	f	I have seen some parts of the world and not on...	f	t	NaN	2018-10-31	2018-11-07	52.529071	NaN	https://www.airbnb.com/rooms/17409	13.412843	Berlin	30	NaN	3	$955.00	Downtown Above The Roofs In Berlin	You are in the heart of the former East-Berlin...	Prenzlauer Berg	Prenzlauer Berg Südwest	Pankow	NaN	279	https://a0.muscache.com/im/pictures/9964850/c5...	$45.00	Condominium	f	f	t	10.0	10.0	10.0	10.0	10.0	96.0	10.0	2.83	Private room	20181107122246	$0.00	Berlin, Germany	A 25 sqm room in the heart of Berlin. Many pla...	NaN	Berlin	Berlin, Berlin, Germany	The 25 sqm room is located in the heart of Ber...	NaN	The subway is just a two minutes walk away, th...	$281.00	NaN	10405

Last rows

	access	accommodates	amenities	availability_30	availability_365	availability_60	availability_90	bathrooms	bed_type	bedrooms	beds	calculated_host_listings_count	calendar_last_scraped	calendar_updated	cancellation_policy	city	cleaning_fee	country	country_code	description	experiences_offered	extra_people	first_review	guests_included	has_availability	host_about	host_acceptance_rate	host_has_profile_pic	host_id	host_identity_verified	host_is_superhost	host_listings_count	host_location	host_name	host_neighbourhood	host_picture_url	host_response_rate	host_response_time	host_since	host_thumbnail_url	host_total_listings_count	host_url	host_verifications	house_rules	id	instant_bookable	interaction	is_business_travel_ready	is_location_exact	jurisdiction_names	last_review	last_scraped	latitude	license	listing_url	longitude	market	maximum_nights	medium_url	minimum_nights	monthly_price	name	neighborhood_overview	neighbourhood	neighbourhood_cleansed	neighbourhood_group_cleansed	notes	number_of_reviews	picture_url	price	property_type	require_guest_phone_verification	require_guest_profile_picture	requires_license	review_scores_accuracy	review_scores_checkin	review_scores_cleanliness	review_scores_communication	review_scores_location	review_scores_rating	review_scores_value	reviews_per_month	room_type	scrape_id	security_deposit	smart_location	space	square_feet	state	street	summary	thumbnail_url	transit	weekly_price	xl_picture_url	zipcode
443	NaN	2	{TV,Wifi,Kitchen,"Buzzer/wireless intercom",He...	0	155	0	0	1.0	Real Bed	1.0	1.0	1	2018-11-07	2 weeks ago	strict_14_with_grace_period	Berlin	$30.00	Germany	DE	From the 1st of May 2016: Due to a new legisla...	none	$19.00	2012-05-08	1	t	It is great to be host to friendly people from...	NaN	t	2236088	t	f	1	Berlin, Berlin, Germany	Ingo	Prenzlauer Berg	https://a0.muscache.com/im/users/2236088/profi...	50%	within a day	2012-04-27	https://a0.muscache.com/im/users/2236088/profi...	1	https://www.airbnb.com/users/show/2236088	['email', 'phone', 'reviews', 'kba']	Strictly no Smoking (except on the balcony) an...	450325	f	NaN	f	t	NaN	2018-07-08	2018-11-07	52.538508	NaN	https://www.airbnb.com/rooms/450325	13.406859	Berlin	1125	NaN	60	NaN	gorgeous old chocolate factory	The Schwedter Strasse is a great location to s...	Prenzlauer Berg	Prenzlauer Berg Südwest	Pankow	NaN	55	https://a0.muscache.com/im/pictures/9531486/ae...	$109.00	Loft	t	t	t	10.0	10.0	10.0	10.0	10.0	99.0	10.0	0.69	Entire home/apt	20181107122246	$1,000.00	Berlin, Germany	From the 1st of May 2016: Due to a new legisla...	592.0	Berlin	Berlin, Berlin, Germany	NaN	NaN	There are four tube stations nearby: Eberswald...	NaN	NaN	10435
444	private parking space in the house. terrace, b...	5	{TV,Internet,Wifi,"Wheelchair accessible",Kitc...	0	252	0	0	2.0	Real Bed	3.0	5.0	1	2018-11-07	4 months ago	strict_14_with_grace_period	Berlin	$60.00	Germany	DE	beautiful 130 m2 loft-like apartment on the fo...	none	$25.00	2013-07-06	1	t	I love traveling and I love beautiful homes. W...	NaN	t	2246564	t	f	1	Berlin, Berlin, Germany	Kim	Mitte	https://a0.muscache.com/im/users/2246564/profi...	NaN	NaN	2012-04-29	https://a0.muscache.com/im/users/2246564/profi...	1	https://www.airbnb.com/users/show/2246564	['email', 'phone', 'reviews', 'jumio', 'govern...	during the summer, it would be great if our pl...	452164	f	I'll be answering all questions via email thou...	f	t	NaN	2017-04-13	2018-11-07	52.531104	NaN	https://www.airbnb.com/rooms/452164	13.388507	Berlin	31	NaN	5	NaN	In the middle of Mitte and green!	very quiet neighborhood, but close to all shop...	Mitte	Brunnenstr. Süd	Mitte	NaN	6	https://a0.muscache.com/im/pictures/17689959/e...	$130.00	Apartment	f	f	t	10.0	10.0	9.0	10.0	10.0	100.0	9.0	0.09	Entire home/apt	20181107122246	$250.00	Berlin, Germany	Wonderful big 130 qm apartment in Mitte or so ...	1399.0	Berlin	Berlin, Berlin, Germany	beautiful 130 m2 loft-like apartment on the fo...	NaN	Trainstation Nordbahnhof 300m from our door. G...	NaN	NaN	10115
445	NaN	2	{Internet,Wifi,Kitchen,Heating,"Family/kid fri...	22	339	40	70	1.0	Real Bed	1.0	1.0	1	2018-11-07	1 week ago	moderate	Berlin	$40.00	Germany	DE	We offer a charming converted cottage in a hug...	none	$30.00	2012-08-29	2	t	I am a journalist and mother of wonderful twin...	NaN	t	1981166	f	f	1	Berlin, Berlin, Germany	Ilka	Zehlendorf	https://a0.muscache.com/im/users/1981166/profi...	NaN	NaN	2012-03-21	https://a0.muscache.com/im/users/1981166/profi...	1	https://www.airbnb.com/users/show/1981166	['email', 'phone', 'facebook', 'reviews']	Gäste nur nach Absprache. Die Privatsphäre des...	456839	f	NaN	f	f	NaN	2018-10-05	2018-11-07	52.437196	NaN	https://www.airbnb.com/rooms/456839	13.242451	Berlin	90	NaN	2	$1,800.00	Charming converted cottage	NaN	Zehlendorf	Zehlendorf Nord	Steglitz - Zehlendorf	NaN	13	https://a0.muscache.com/im/pictures/5654349/5a...	$90.00	House	f	f	t	10.0	10.0	10.0	10.0	10.0	100.0	10.0	0.17	Entire home/apt	20181107122246	NaN	Berlin, Germany	We offer a charming converted cottage in a hug...	0.0	Berlin	Berlin, Berlin, Germany	NaN	NaN	NaN	$590.00	NaN	14163
446	Access to the whole apartment.	4	{TV,Internet,Wifi,Kitchen,"Paid parking off pr...	6	254	13	34	1.0	Real Bed	1.0	1.0	1	2018-11-07	3 days ago	strict_14_with_grace_period	Berlin	$30.00	Germany	DE	Comfortable and cosy Apartment in a very nice ...	none	$15.00	2012-08-04	2	t	Es macht Spass Gastgeber hier in Berlin zu sei...	NaN	t	2271792	t	t	1	Berlin, Berlin, Germany	Stefan	Kreuzberg	https://a0.muscache.com/im/users/2271792/profi...	NaN	NaN	2012-05-02	https://a0.muscache.com/im/users/2271792/profi...	1	https://www.airbnb.com/users/show/2271792	['email', 'phone', 'facebook', 'reviews', 'jum...	This is a no smoking apartment.	456902	f	We live next door to the flat. So if you´ve go...	f	t	NaN	2018-11-01	2018-11-07	52.492952	NaN	https://www.airbnb.com/rooms/456902	13.412858	Berlin	1125	NaN	2	$1,400.00	Maisonette Apartment in Kreuzberg	Who wants to experience Berlin is here in the ...	Kreuzberg	Tempelhofer Vorstadt	Friedrichshain-Kreuzberg	The apartment is perfect for couples, a good p...	211	https://a0.muscache.com/im/pictures/5339551/77...	$83.00	Loft	f	f	t	10.0	10.0	10.0	10.0	10.0	98.0	10.0	2.77	Entire home/apt	20181107122246	NaN	Berlin, Germany	Welcome to the center of Berlin. Since January...	NaN	Berlin	Berlin, Berlin, Germany	Comfortable and cosy Apartment in a very nice ...	NaN	U7 (to Kurfürstendamm/City West): U-Südstern 5...	$483.00	NaN	10967
447	Unseren schönen Garten dürfen Sie gemeinsam mi...	4	{TV,Wifi,Kitchen,"Pets allowed","Pets live on ...	25	352	47	77	1.0	Real Bed	2.0	2.0	1	2018-11-07	yesterday	flexible	Berlin	$40.00	Germany	DE	Rest and relaxation in Berlin? This is, like I...	none	$0.00	2012-08-30	4	t	Ich freue mich darauf Euch in meiner Wohnung z...	NaN	t	978210	f	f	1	Berlin, Berlin, Germany	Hannelore	Karow	https://a0.muscache.com/im/users/978210/profil...	100%	within an hour	2011-08-16	https://a0.muscache.com/im/users/978210/profil...	1	https://www.airbnb.com/users/show/978210	['email', 'phone', 'reviews']	Wir erwarten angenehme Gäste . Keine Partyfan...	458586	f	Ich bin jederzeit für Sie ansprechbar. Die Woh...	f	t	NaN	2018-11-03	2018-11-07	52.603266	NaN	https://www.airbnb.com/rooms/458586	13.481914	Berlin	30	NaN	2	$1,500.00	You are looking for peace and relax	Unsere Umgebung ist ein ländliches Umfeld in ...	Karow	Karow	Pankow	Bitte beachten Sie: Rauchen nur in der Veranda...	77	https://a0.muscache.com/im/pictures/34865559/3...	$70.00	Apartment	t	t	t	10.0	10.0	10.0	10.0	9.0	94.0	10.0	1.02	Entire home/apt	20181107122246	$200.00	Berlin, Germany	Rest and relaxation in Berlin? This is, like I...	NaN	Berlin	Berlin, Berlin, Germany	Berlin ist wunderschön.Das bestätigen unsere G...	NaN	Busse, S-Bahn, Fernbahn auch ins Umland. Park...	$440.00	NaN	13125
448	Spacious and sunny room with double bed 140 x ...	2	{Internet,Kitchen,"Pets allowed",Elevator,"Buz...	0	0	0	0	1.0	Real Bed	1.0	1.0	1	2018-11-07	11 months ago	moderate	Berlin	$80.00	Germany	DE	In the heart of Berlin Kreuzberg: between Vikt...	none	$20.00	2012-06-04	1	t	Hallo, \r\nich freue mich über interessante Gä...	NaN	t	2280531	f	f	2	Berlin, Berlin, Germany	Cornelia	Kreuzberg	https://a0.muscache.com/im/pictures/9296d406-c...	NaN	NaN	2012-05-03	https://a0.muscache.com/im/pictures/9296d406-c...	2	https://www.airbnb.com/users/show/2280531	['email', 'phone', 'facebook', 'reviews']	Our neighbours are very nice and friendly. Ple...	458608	t	NaN	f	t	NaN	2018-01-31	2018-11-07	52.486873	NaN	https://www.airbnb.com/rooms/458608	13.386211	Berlin	75	NaN	2	NaN	bright apartment in Berlin Kreuzberg	NaN	Kreuzberg	Tempelhofer Vorstadt	Friedrichshain-Kreuzberg	Ich habe 2 freundliche Katzen, die aber nicht ...	14	https://a0.muscache.com/im/pictures/5443010/c8...	$60.00	Apartment	f	f	t	10.0	10.0	9.0	10.0	10.0	98.0	10.0	0.18	Entire home/apt	20181107122246	$500.00	Berlin, Germany	This great 3 room apartment is located near th...	NaN	Berlin	Berlin, Berlin, Germany	In the heart of Berlin Kreuzberg: between Vikt...	NaN	U6 (Flughafen Tegel), U7 (Flughafen Schönefeld)	NaN	NaN	10965
449	NaN	5	{TV,"Cable TV",Internet,Wifi,Kitchen,"Buzzer/w...	0	5	5	5	1.5	Real Bed	3.0	5.0	2	2018-11-07	3 weeks ago	strict_14_with_grace_period	Berlin	NaN	Germany	DE	4 room apartment (2nd floor, 120m²): 3 BR, hu...	none	$0.00	2012-07-11	1	t	-	NaN	t	2281237	f	f	2	Berlin, Berlin, Germany	Antje	Prenzlauer Berg	https://a0.muscache.com/im/users/2281237/profi...	100%	within a day	2012-05-03	https://a0.muscache.com/im/users/2281237/profi...	2	https://www.airbnb.com/users/show/2281237	['email', 'phone', 'reviews']	NaN	458800	f	We are happy to offer suggestions for activiti...	f	t	NaN	2018-10-29	2018-11-07	52.540408	NaN	https://www.airbnb.com/rooms/458800	13.421441	Berlin	7	NaN	2	NaN	Beautiful 3BR, Excellent location	Der schönste Kiez Berlins	Prenzlauer Berg	Helmholtzplatz	Pankow	NaN	10	https://a0.muscache.com/im/pictures/1af74bc1-b...	$209.00	Apartment	f	f	t	10.0	10.0	10.0	10.0	10.0	89.0	9.0	0.13	Entire home/apt	20181107122246	NaN	Berlin, Germany	We are subletting our private apartment during...	1238.0	Berlin	Berlin, Berlin, Germany	4 room apartment (2nd floor, 120m²): 3 BR, hu...	NaN	Sie erreichen die Tram und U Bahn in wenigen M...	$1,100.00	NaN	10437
450	NaN	2	{TV,Internet,Wifi,Kitchen,"Pets allowed",Eleva...	0	0	0	0	1.0	Real Bed	1.0	1.0	1	2018-11-07	2 months ago	strict_14_with_grace_period	Berlin	$60.00	Germany	DE	- 90 m² / 970 square feet right at the edge of...	none	$0.00	2012-05-22	2	t	Berlin based	NaN	t	311022	t	f	1	Berlin, Berlin, Germany	Antonia	Prenzlauer Berg	https://a0.muscache.com/im/users/311022/profil...	100%	within a few hours	2010-12-06	https://a0.muscache.com/im/users/311022/profil...	1	https://www.airbnb.com/users/show/311022	['email', 'phone', 'reviews', 'jumio', 'govern...	NaN	462459	f	NaN	f	t	NaN	2018-05-31	2018-11-07	52.532849	NaN	https://www.airbnb.com/rooms/462459	13.419732	Berlin	365	NaN	4	NaN	COOL BERLIN MITTE FLAT	NaN	Prenzlauer Berg	Prenzlauer Berg Südwest	Pankow	NaN	9	https://a0.muscache.com/im/pictures/18033618/1...	$70.00	Apartment	f	f	t	10.0	10.0	10.0	10.0	9.0	95.0	9.0	0.11	Entire home/apt	20181107122246	$350.00	Berlin, Germany	- 90 m² / 970 square feet right at the edge of...	NaN	Berlin	Berlin, Berlin, Germany	NaN	NaN	- right in front of the door the tram M2 is ru...	NaN	NaN	10405
451	You have your own private room and we share ba...	2	{Internet,Wifi,Kitchen,"Free street parking","...	7	18	11	18	1.0	Real Bed	1.0	1.0	1	2018-11-07	6 days ago	moderate	Berlin	NaN	Germany	DE	this is a real berlin experience /// I’m offe...	none	$30.00	2012-05-15	1	t	I am a vegetarian and I am into yoga\r\nand lo...	NaN	t	2266593	t	f	1	Berlin, Berlin, Germany	Gudrun	Kreuzberg	https://a0.muscache.com/im/users/2266593/profi...	100%	within a few hours	2012-05-01	https://a0.muscache.com/im/users/2266593/profi...	1	https://www.airbnb.com/users/show/2266593	['email', 'phone', 'facebook', 'reviews', 'jum...	while it's of course totally cool for you to e...	464324	f	If you have any questions just let me know I'd...	f	t	NaN	2018-10-29	2018-11-07	52.487942	NaN	https://www.airbnb.com/rooms/464324	13.375042	Berlin	120	NaN	3	$700.00	spacious room in light-flooded classy apartment	Location ///////////// from my apartment you o...	Kreuzberg	Tempelhofer Vorstadt	Friedrichshain-Kreuzberg	if you plan to stay longer just send me a note...	27	https://a0.muscache.com/im/pictures/100124170/...	$44.00	Apartment	f	f	t	10.0	10.0	10.0	10.0	10.0	99.0	9.0	0.34	Private room	20181107122246	NaN	Berlin, Germany	this is a real berlin experience /// I’m offe...	323.0	Berlin	Berlin, Berlin, Germany	NaN	NaN	get directions on the bvg.de website • the nex...	$259.00	NaN	10965
452	You are able to use free wifi. The kitchen, ba...	2	{Internet,Wifi,Kitchen,"Buzzer/wireless interc...	0	0	0	0	1.5	Real Bed	1.0	2.0	1	2018-11-07	8 months ago	strict_14_with_grace_period	Berlin	$35.00	Germany	DE	50-sqm part of my beautiful light non-smoking ...	none	$12.00	2015-05-04	1	t	I am a real Berliner, born and raised in Berli...	NaN	t	2017884	t	f	1	Berlin, Berlin, Germany	Claudia	Mitte	https://a0.muscache.com/im/pictures/user/9bdd4...	NaN	NaN	2012-03-27	https://a0.muscache.com/im/pictures/user/9bdd4...	1	https://www.airbnb.com/users/show/2017884	['email', 'phone', 'facebook', 'reviews', 'kba...	Looking for friendly care taking people, no pa...	466983	t	Da ich eine echte Berlinerin bin, erzähle ich ...	f	f	NaN	2018-04-01	2018-11-07	52.529863	NaN	https://www.airbnb.com/rooms/466983	13.410079	Berlin	60	NaN	3	$1,200.00	beautiful light room in 100qm place	Tolle Geschäfte, Restaurants, Bars, sowie Thea...	Prenzlauer Berg	Prenzlauer Berg Südwest	Pankow	NaN	75	https://a0.muscache.com/im/pictures/12089103/6...	$34.00	Apartment	f	f	t	10.0	9.0	9.0	9.0	10.0	92.0	9.0	1.75	Private room	20181107122246	$250.00	Berlin, Germany	I am renting 50-sqm, one big room 25qm and 25q...	269.0	Berlin	Berlin, Berlin, Germany	50-sqm part of my beautiful light non-smoking ...	NaN	Walking Distances: - Rosenthaler Platz: 2 Minu...	$350.00	NaN	10119

Overview

Variables

Correlations

Missing values

Sample

First rows

Last rows